Insert Date

Hi,
I just imported about 1000 records into mysql db.

There is a date field "created", which I missed, and all the dates in the db read:
0000-00-00 00:00:00

Is there a way to easily change all the date fields to one date?

I am not real experienced with dbs.

 

Yes, run something like this.

UPDATE my_table SET date_field = NOW();

or

UPDATE my_table SET date_field = '2005-01-05 00:00:00';

 

UPDATE my_table SET date_field = '2009-09-09 00:00:00'; one shot

 

As I mentioned, kinda dumb when it comes to db.

Where/how exactly do I run this update?

 

Do you have ssh or phpmyadmin? You need to run that script in a command line prompt. phpmyadmin has one. Otherwise if you have SSH access to the server, you can run it directly from there.

 

you can use update query to update existing record. You can insert current date using date('y-m-d') it will insert current date to mysql field

 

If you don't use PHPMyAdmin, just use the same script you used to upload the data in the first place. But instead of INSERT queries, you'll have the one UPDATE query.

 

i had same problem