List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 21 2001 1:40am
Subject:Re: inserting special characters
View as plain text  
At 1:24 AM +0000 2/21/01, efreyre@stripped wrote:
>Dear Sirs :
>
>Please I would want to konw How I can insert special
>characters into a table,
>
>Since the " and ' chars are used for delimiting values into
>an insert statement I don¥t know how I can put these as part
>the string that I inserting.

Put a backslash in front of them.

http://www.mysql.com/doc/S/t/String_syntax.html

>
>I got this putting the data into a file, and then using the
>load data infile... statement, So all has been loaded
>correctly (including the " symbol). But I would want get it
>from the command line with an insert statement directly.
>
>Can someone help me ??
>
>Thank you in advance
>
>Best Regards.
>Ernesto


-- 
Paul DuBois, paul@stripped
Thread
inserting special charactersefreyre21 Feb
Re: inserting special charactersRolf Hopkins21 Feb
Re: inserting special charactersPaul DuBois21 Feb