RE: Plus sign doesn't concatenate strings in MySQL?

At 20:32 -0500 1/15/05, Dave Merrill wrote: Let me ask a slightly different question: Is there a string concatenation operator in mysql when it's *not* running in ansi mode? Or is the only way to accomplish that to use CONCAT? I think I'm hearing that there is no operator, only CONCAT. Right? Right

RE: Plus sign doesn't concatenate strings in MySQL?

Let me ask a slightly different question: Is there a string concatenation operator in mysql when it's *not* running in ansi mode? Or is the only way to accomplish that to use CONCAT? I think I'm hearing that there is no operator, only CONCAT. Right? Dave Merrill -- MySQL General Mailing List

RE: Plus sign doesn't concatenate strings in MySQL?

Um, I know that probably seemed a bit random, but I got a msg from someone saying that was how it worked; it certainly wasn't something I thought, hence the '???'. Your reply leads me to believe that was a private email not sent to the list. Dave Merrill > >??? > > > >SELECT 'asdf' . 'qwer' > > >

Re: Plus sign doesn't concatenate strings in MySQL?

Starting with 4.0, MySQL can be made to respect the standard of || as the concatenation operator with the PIPES_AS_CONCAT sql-mode. You may want to read section 1.5, "MySQL Standards Compliance", in the manual . There are some options to m

RE: Plus sign doesn't concatenate strings in MySQL?

At 8:51 -0500 1/15/05, Dave Merrill wrote: ??? SELECT 'asdf' . 'qwer' ...gives "Error Code : 1064, You have an error in your SQL syntax..." I also can't find any reference to this use of periods in the docs. Mostly we document how MySQL works, not all the things that you could possibly try that won

Re: Plus sign doesn't concatenate strings in MySQL?

At 18:04 +0100 2005/01/15, Jochem van Dieten wrote: On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from. DBMS's are not languages, they a

Re: Plus sign doesn't concatenate strings in MySQL?

On Sat, 15 Jan 2005 11:37:02 -0500, Dave Merrill wrote: > > This is my first foray into different flavors of sql, and I'm discovering > how incompatible they really are. I expected that core basics would be the > same, with each manufacturer adding some proprietary extensions, and failing > to sup

Re: Plus sign doesn't concatenate strings in MySQL?

Jochem van Dieten wrote: On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from. DBMS's are not languages, they are implementations. Might no

Re: Plus sign doesn't concatenate strings in MySQL?

On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: > > Each language is going to have its own personality. If they all did > things the same way, we wouldn't have the wealth of different ones to > choose from. DBMS's are not languages, they are implementations. > Might not be a good i

RE: Plus sign doesn't concatenate strings in MySQL?

As I said in my msg, I found out that I was wrong, '+' isn't ANSI, it's just microsoft. But mysql doesn't support the ANSI standard '||' either. Go figure... This is my first foray into different flavors of sql, and I'm discovering how incompatible they really are. I expected that core basics wou

Re: Plus sign doesn't concatenate strings in MySQL?

At 07:37 -0500 2005/01/15, Dave Merrill wrote: I thought string concatenation w '+' was totally standard SQL. Hmmm, this is the first I've heard of "+" being used for concatenation (in SQL). Then again, I've never used MS SQL Server. :-) Each language is going to have its own personality. If th

RE: Plus sign doesn't concatenate strings in MySQL?

??? SELECT 'asdf' . 'qwer' ...gives "Error Code : 1064, You have an error in your SQL syntax..." I also can't find any reference to this use of periods in the docs. Have you tried it? Can you point me to something that says it ought to work? BTW, I'm trying this w mysql 4.1.7-nt-max on win2k, i