the table.
As you see you don't have the Comma character.
Aloha!
Claudio Nanni
-Messaggio originale-
Da: J. Todd Slack [mailto:[EMAIL PROTECTED]
Inviato: sabato 8 marzo 2008 8.53
A: mysql@lists.mysql.com
Oggetto: Comma's in data?
Hi All,
I have a client that wants to insert data
[EMAIL PROTECTED]
To: J. Todd Slack [EMAIL PROTECTED];
mysql@lists.mysql.com
Sent: Sunday, March 09, 2008 1:00 AM
Subject: Re: Comma's in data?
At 11:52 PM -0800 3/7/08, J. Todd Slack wrote:
Hi All,
I have a client that wants to insert data into a VarChar field that
contains
commas
Use \ to escape.
mysql insert into table1 values ('algo\,otra');
Query OK, 1 row affected (0.00 sec)
mysql select * from table1;
+---+
| a |
+---+
| algo |
| algo,otra |
+---+
2 rows in set (0.00 sec)
On Sat, Mar 8, 2008 at 1:52 AM, J. Todd Slack
[EMAIL
At 12:23a -0500 on Sat, 08 Mar 2008, obed wrote:
Use \ to escape.
mysql insert into table1 values ('algo\,otra');
As an aside, I'm curious why the parser doesn't understand that the
comma is part of the string in this context? It's already between two
single quotes ... ? Shouldn't that be
At 11:52 PM -0800 3/7/08, J. Todd Slack wrote:
Hi All,
I have a client that wants to insert data into a VarChar field that contains
commas. These are property addresses.
Example:
2966 Moorpark Ave, San Jose, CA, 95128
1 Infinite Loop, Cupertino, CA, 95
How can I allow this?
Thanks!
Hi All,
I have a client that wants to insert data into a VarChar field that contains
commas. These are property addresses.
Example:
2966 Moorpark Ave, San Jose, CA, 95128
1 Infinite Loop, Cupertino, CA, 95
How can I allow this?
Thanks!
-Jason