Select count (*) from ps_product;select count (*) from ps_product_lang;select * from ps_product_lang where id_product= (Select count (*) from ps_ Product_lang); select name,id_product from ps_product_lang where id_product= (select count (*) from ps_product_lang); Select name,id_product from ps_product_lang where id_product=;select name,id_product from ps_product_lang where name= ' '; select count (*) from ps_product where price=0;delete from ps_product where id_product=;d Elete from ps_product_lang where id_product between 4076 and 4079;delete from ps_product where id_product between 4080 and 4082;delete from ps_category where id_category between 4080 and 4082;delete from&nbsP;ps_product_lang where id_product in (274,233,241,339,654); update ps_product_lang set description= " " where description= ""; (change note) update ps_product_lang set price=price+179; (change price) Delete from ps_product_lang where id_product%2=0 and id_product>666;update ps_ Category set id_parent=2 where id_category between 9 and 11;update ps_image set cover = 0 where id_product=5;update ps_image set cover = 1 where id_image=9;select name,id_product from ps_product_ Lang where name=10465;update ps_product set active = 0 where id_ product in (); select count (*) from ps_product where pricr<100; update ' ps_product ' SET ' price ' = concat (Round (rand () *200 + 120), '. 99 ') where price<100;select * from ps_feature where id_feature = 18; Select * from ps_feature_lang where id_feature = 18;select * from ps_feature_value_lang where value= ' Bateau (2) Bateau neck (9) bateau neck/strapless '; Select count (*) from ps_feature_value_lang;update ps_feature_product set id_feature = 19 Where id_feature = 18;update ps_feature_product set id_feature = 28 where id_feature = 16;update ps_feature_product set id_feature = 15 where id_feature = 20;update ps_feature_product set id_feature = 8 where id_feature = 6;delete from ps_feature where id_ feature in (18,16,20,6);delete from ps_feature_lang where id_feuture in (18,16,20,6); update ps_ Feature_product set id_feature_value=50 where id_feature_value in (72,364,59,351); Select * from ps_feature_lang where name= ' Style '; Insert order number truncate ' ps_orders '; I nsert into ' ps_orders ' (' id_order ', ' id_carrier ', ' Id_lang ', ' Id_customer ', ' Id_cart ', ' id_currency ', ' id_address_delivery ', ' id_address_invoice ', ' Secure_key ', ' payment ', ' conversion_rate ', ' module ', ' recyclable ', ' gift ', ' gift_message ', ' Shipping_number ', ' total_discounts ', ' total_paid ', ' total_paid_real ', ' Total_ Products ', ' total_products_wt ', ' total_shipping ', ' carrier_tax_rate ', ' total_wrapping ', ' Invoice_number ', ' delivery_number ', ' invoice_date ', ' delivery_date ', ' valid ', ' Date_add ', ' date_upd ') values (' 960000 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1.000000 ', ' 1 ', ' 0 ', ' 0 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 1 ', ' 2011-08-03 00:00:00 ', ' 2011-08-03 00:00:00 ', ' 1 ', ' 2011-08-03 00:00:00 ', ' 2011-08-03 00:00:00 '); select id_ order from ps_orders;delete from ps_orders; Deleting a product Delete from ps_product where id_product>6404;delete from ps_product_lang where id_product>6404;delete From ps_category_product where id_product>6404;delete from ps_image where id_product > 6404;delete from ps_product_tag where id_product ; Reclassification update ps_category_product set id_category=4 where id_category = 7; Update ps_category_product set id_category=2 where id_category in (15,17,13,23); update ps_category_ Product set id_category=36 where id_category=35;update ps_category_product set id_category=14 where id_category=34; Modify MySQL Password: Classification becomes sub-category Update ps_category_product set id_parent=14 where id_category=34;
Some additions and deletions to the database to change the operation