Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Mark Matthews
Robert Fox wrote: >Hi Frank- > >I'm new to the MySQL world, and I am also a DBA with an Oracle background. >This was a surprise to me as well. However, the only solution that I know >of is to encapsulate your SELECT elements in a Concat() function. So, your >SQL statement would be: > >select c

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Mark Goodge
At 20:46 26/09/2002 +0200, MySQL wrote: >Hi all, > >I'm a DBA in the Oracle World. > >I want to make a sql query in mysql, with a concat (||) known i Oracle >world. > >Like this. > >select numer ||','|| text from Table: You need to specify the keyword CONCAT and enclose it in brackets, like this:

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Robert Fox
Hi Frank- I'm new to the MySQL world, and I am also a DBA with an Oracle background. This was a surprise to me as well. However, the only solution that I know of is to encapsulate your SELECT elements in a Concat() function. So, your SQL statement would be: select concat(numer, text) from tab

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Brent Baisley
You almost answered your own question. In mysql you use the concat() command: select concat(number,',',text) from Table On Thursday, September 26, 2002, at 03:17 PM, MySQL wrote: > Hi all, > > I'm a DBA in the Oracle World. > > I want to make a sql query in mysql, with a concat (||) known i Ora

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Rodney Broom
From: MySQL <[EMAIL PROTECTED]> > select numer ||','|| text from Table: SELECT CONCAT(numer, '||', text) FROM Table; --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ - Before posting, please check:

RE: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Bryan
;First name",NULL,"Last Name"); -> 'First name,Last Name' -=Bryan=- -Original Message- From: MySQL [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 11:47 AM To: [EMAIL PROTECTED] Subject: Mysql vs. Oracle and concat "||" Hi all,

Re: Mysql vs. Oracle and concat '||'

2002-09-26 Thread Jeff Kilbride
Hi Frank, You can use the concat() function: select concat(numer, ',', text) from Table. The online docs for MySQL contain a great reference for functions: http://www.mysql.com/doc/en/Functions.html --jeff > Hi all, > > I'm a DBA in the Oracle World. > > I want to make a sql query in mysql,

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread sherzodr
:I want to make a sql query in mysql, with a concat (||) known i Oracle :world. : :Like this. : :select numer ||','|| text from Table: Instead, try the following: SELECT CONCAT(number, ',', text) FROM Table; - Before

RE: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Andrew Braithwaite
ect: Mysql vs. Oracle and concat "||" Hi all, I'm a DBA in the Oracle World. I want to make a sql query in mysql, with a concat (||) known i Oracle world. Like this. select numer ||','|| text from Table: Where the output will be eg. 1,HI 2,Frank And so on Hope

Re: Mysql vs. Oracle and concat "||"

2002-09-26 Thread Jocelyn Fournier
sday, September 26, 2002 8:46 PM Subject: Mysql vs. Oracle and concat "||" > Hi all, > > I'm a DBA in the Oracle World. > > I want to make a sql query in mysql, with a concat (||) known i Oracle > world. > > Like this. > > select numer ||',

Mysql vs. Oracle and concat "||"

2002-09-26 Thread MySQL
Hi all, I'm a DBA in the Oracle World. I want to make a sql query in mysql, with a concat (||) known i Oracle world. Like this. select numer ||','|| text from Table: Where the output will be eg. 1,HI 2,Frank And so on Hope one of you can see my problem. I've tried the same on mysql, bu

Mysql vs. Oracle and concat "||"

2002-09-26 Thread MySQL
Hi all, I'm a DBA in the Oracle World. I want to make a sql query in mysql, with a concat (||) known i Oracle world. Like this. select numer ||','|| text from Table: Where the output will be eg. 1,HI 2,Frank And so on Hope one of you can see my problem. I've tried the same on mysql, bu