Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
11-03-2011, 04:05 PM #1
- Join Date
- Jul 2009
- Thanked 0 Times in 0 Posts
how to update the record with batch in phpmyadmin
the table named: products. it have five hundred rows record. the table have field roducts_model products_price. the products_model is unique。
the original value that stored in products table are all 0.0000. now i want to update it with batch in phpmyadmin according to the 'products_model`.
i prepared the data in excel with two columns, 'products_modelthe new valueproducts_price`(according to some reason, some may be empty). how do i do? thank you.
the data form a csv file :