HELP With UPDATE Query in mySQL
| From: | Shaun | Date: | Fri, 03 Oct 2003 21:54:49 +0000 |
| Subject: | HELP With UPDATE Query in mySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30833@lists.php.net to get a copy of this message | ||
Hi,
I have two columns in my Bookings table of type DATETIME -
Booking_Start_Date and Boking_End_Date. How can i update every row so that
all of the times for Booking_Start_Date are 09.00 and all of the times for
Booking_End_Date are 17.30, without affecting any of the dates?
Thanks for your help