At 1:24 AM +0000 2/21/01, [EMAIL PROTECTED] 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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php