Page 1 of 1

phpmyadmin, MySql export >>> get UPDATE using WHERE

Posted: Wed Apr 25, 2007 4:50 pm
by glennn.php
i have a db with two tables, product_id and product_image, in that order, about 480 records.

i'd LOVE IT if there was a way to export this table/query so as to get UPDATE product_image = 'x' WHERE product_id = '1';

anybody? many thanks ---

gn

Posted: Fri Apr 27, 2007 1:08 am
by Christopher
I am not clear exactly what you are trying to do, but I sometimes use a spreadsheet to create many SQL statements from exported data. Perhaps you could export your image table and then create your UPDATE statements for the product table from that.