Re: escape character within sql statement.

[Stephan Lukits]

Hi,
where a1="Here's"
You need to escape the ' character with a backslash before you send the 
query to the server.
If you develope with C this link might be useful:
http://www.mysql.com/doc/en/mysql_real_escape_string.html
If you develope wit perl + DBI there comes a quote methode with the DBI 
package - if I remember right - which escapes the characters which need 
escaping.
How to use/escape strings properly is documented at this webside:
http://www.mysql.com/doc/en/String_syntax.html

best regards
Stephan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]