phpmyadmin, MySql export >>> get UPDATE using WHERE

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
glennn.php
Forum Commoner
Posts: 41
Joined: Sat Jul 08, 2006 12:26 pm

phpmyadmin, MySql export >>> get UPDATE using WHERE

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post 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.
(#10850)
Post Reply