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,

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,

Re: Mysql vs. Oracle and concat ||

2002-09-26 Thread Jocelyn Fournier
: 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 one of you can see my

RE: Mysql vs. Oracle and concat ||

2002-09-26 Thread Andrew Braithwaite
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 one of you can see my problem. I've

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; -

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 Bryan
To: [EMAIL PROTECTED] 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 ||','|| 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 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 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 Oracle

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

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 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