> I have been trying to concatenate two fields with MySql contaning the
> NAME and SURNAME, whatever tool I use, it returns me all the time a
> "number". What it is wrong with my request?
Hard to tell without showing your query, isn't it?
With regards,
Martijn Tonies
Database Workbench - deve
I have been trying to concatenate two fields with MySql contaning the
NAME and SURNAME, whatever tool I use, it returns me all the time a
"number". What it is wrong with my request?
thanks
[EMAIL PROTECTED]
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://
astname AS fullname
FROM customers
But if MySQL isn't in ANSI mode (specifically, the PIPES_AS_CONCAT
part), which is typical since it's not enabled by default, || is logical
OR. :-(
Matt
You can also use simple proximity as a concatenation "operator":
mysql> select 'hell
t if MySQL isn't in ANSI mode (specifically, the PIPES_AS_CONCAT
part), which is typical since it's not enabled by default, || is logical
OR. :-(
Matt
- Original Message -
From: "Jim McAtee"
Sent: Thursday, March 18, 2004 4:29 PM
Subject: String Concatenation Operator
> or must you use the CONCAT() function?
Yes
SELECT concat(firstname,' ',lastname) AS fullname FROM customers;
Cheers,
Andrew
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Thursday 18 March 2004 22:30
To: [EMAIL PROTECTED]
Subject: String Concatena
Does MySQL have a string contatenation operator, or must you use the
CONCAT() function?
SELECT firstname + ' ' + lastname AS fullname
FROM customers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
name in MySQL.
Cheers,
Andrew
Mysql,query
-Original Message-
From: Chris Stark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 12 December 2002 18:58
To: '[EMAIL PROTECTED]'
Subject: Collective Row Concatenation
Hi,
I am having a bit of a problem with my MySQL database,
Hi,
I am having a bit of a problem with my MySQL database, and I am
hoping someone can help me out. I have a table, that currently contains 350
million rows, all of which basically contain a String (VARCHAR) of size 60
characters or less, and a bunch of other identifiers. These 350 milli
The following SQL statement:
mysql> SELECT equipment_name FROM equipment;
Returns the following resultset:
+---+
| equipment_name|
+---+
| Easel |
| Paper Grocery Bag |
| Paper Plates |
| Colored Pencils |
+---+
Is it possi
