update tablename set field1=value1,field2=value2 where field3=value3----- Original Message ----- From: "Lamar Upshaw" <lupshaw@xxxxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx> Sent: Wednesday, December 10, 2008 8:15 PM Subject: MySQL - Question on syntax
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
__________View the list's information and change your settings at //www.freelists.org/list/programmingblind