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