Update multiple rows with one query?

[Tony121076]

I need to update the date columb in every row to the reflect the current date. I know how to do the date but how do I update every row at once? Can I just leave out the WHERE ?

I know I should try this before posting a question here, but I'm new to this, and it will take me forever to set up another database to test this. Thank you for your time and attention.

[Ace]

Or, u can do as I do mostly now...

CREATE TABLE new_temptable SELECT * FROM `org_table`

And u have a copy of a table u can mess with

Ace

[Elena Mitovska]

Yes, you just need to use something like that:

update my_table set column_date=CURRENT_DATE();