Reed Remington
Last Activity: Sep 13 '10, 07:48 PM
Joined: Aug 20 '10
Location: Utah, USA
-
what is the shorthand for updating the same value for all the rows in the table? Maybe this will work for me. -
mysql UPDATE with out specifying the column names
A normal MySQL UPDATE is written:
UPDATE table SET user='Username' , pass='Password' WHERE id='Userid'
I have about 150+ columns of data that need updated. Hoping for some shorthand. Is there a way to send the update with out labeling all the column names? For example:
UPDATE table SET 'Username', 'Password' WHERE id = 'Userid'
i know this can be done in a INSERT if you fill all columns...
No activity results to display
Leave a comment: