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,
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 ||
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
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
: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,
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
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
12 matches
Mail list logo