MySQL - Question on syntax
- From: "Lamar Upshaw" <lupshaw@xxxxxxxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Wed, 10 Dec 2008 10:15:45 -0800
I have two questions:
1. I want to update to fields in a table:
update table set field1=? and field2 =? where filed3=?
What is the correct syntax to accomplish this? I'm getting error messages
when I try. *smile*
2. When I select the time from MySQL, I get the pacific daylight time,
which I figure must be the setting of the clock on the web server I use. How
do I get the GMT time instead of the PDT time?
I'm using perl to connect and send queries and receive results with MySQL.
With All Respect,
Upshaw, Lamar T
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
