mysql UPDATE with out specifying the column names

[Reed Remington]

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 using:

INSERT INTO table VALUES('Username', 'Password')

instead of:

INSERT INTO table(user, pass) VALUES ('Username', 'Password')

[mwasif]

There is no shorthand for UPDATE unless you want to update the same value for all the rows in the table.

[Reed Remington]

what is the shorthand for updating the same value for all the rows in the table? Maybe this will work for me.

[mwasif]

UPDATE query with no WHERE clause will update all rows with the same value e.g.

UPDATE table SET state='NY'

But this is not going to work for you if you want to update different values for different rows.