Some additions and deletions to the database to change the operation

Source: Internet
Author: User

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= "&nbsp;"  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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.