Hello Everyone, I have a few thousand database (MySQL 4.0.16) records that I need to update. The fields are datetime type. I need to subtract 2 hours from each field (to mark changing time zones). Is there something like a UPDATE..SELECT (like the INSERT..SELECT) so I can just change the records with a single SQL statement?
I know how I can use the INTERVAL function in the SELECT statement to get the time difference, but I am not sure how to update the record without some PHP processing. Anyone have any ideas how to do this with just SQL? -- Doug Registered Linux User #285548 (http://counter.li.org) ---------------------------------------- Random Thought: Zero Defects, n.: The result of shutting down a production line. ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
