re: syntax help , sql,query

2002-10-08 Thread Victoria Reznichenko 

Dragos,
Monday, October 07, 2002, 7:30:47 PM, you wrote:

DMP> I am trying to run this update statement, but I got an error syntax...near
DMP> offsetCould You please point out what is wrong?

DMP> Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
DMP> ABBREVIATION is null;

There is no function TO_CHAR() in MySQL.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: syntax help , sql,query

2002-10-08 Thread Roger Baklund 

* Dragos Madalin Popa
> I am trying to run this update statement, but I got an error syntax...near
> offsetCould You please point out what is wrong?
>
> Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
> ABBREVIATION is null;

Use the CONCAT function:

http://www.mysql.com/doc/en/String_functions.html >

--
Roger


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

syntax help , sql,query

2002-10-07 Thread Dragos Madalin Popa 

sql,query

Hi,

I am trying to run this update statement, but I got an error syntax...near
offsetCould You please point out what is wrong?

Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
ABBREVIATION is null;

Thank You,

Best Regards,
Madalin.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php