MySQL Forums
Forum List  »  Newbie

Re: What does a || do?
Posted by: Roland Bouman
Date: July 21, 2005 05:00AM

Yep thats right...
But you can get MySQL to see
||
as string concatenation too when you add PIPES_AS_CONCAT to your sql_mode, as in

SET GLOBAL sql_mode = 'REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,
IGNORE_SPACE';


see http://dev.mysql.com/doc/mysql/en/ansi-mode.html

Options: ReplyQuote


Subject
Written By
Posted
July 20, 2005 12:34PM
July 21, 2005 01:03AM
Re: What does a || do?
July 21, 2005 05:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.