Re: MySQL - Question on syntax

  • From: "black ares" <matematicianu2003@xxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Thu, 11 Dec 2008 18:48:04 +0200

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

Other related posts: