Hi,
Well, why not trying... concat() :)
SELECT concat(numer,',',text) FROM Table;
http://www.mysql.com/doc/en/String_functions.html
Regards,
Jocelyn Fournier
- Original Message -
From: MySQL [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 8:46 PM
Subject:
Hi,
You need to use :
Select concat(numer,',',test) from table;
See: http://www.mysql.com/doc/en/String_functions.html for more.
Cheers,
Andrew
-Original Message-
From: MySQL [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 26 September 2002 19:47
To: [EMAIL PROTECTED]
Subject: Mysql
: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;
-
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,
Concat and Concat_WS from the mysql web site
CONCAT(str1,str2,...)
Returns the string that results from concatenating the arguments.
Returns NULL if any argument is NULL. May have more than 2 arguments. A
numeric argument is converted to the equivalent string form:
mysql SELECT CONCAT('My',
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:
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
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
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:
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
10 matches
Mail list logo
