Examples of methods for escaping characters in MySQL statements

When inserting a string with single or double quotation marks in a MySQL database, consider escaping with a backslash if it is a single string, what if a large amount of data needs to be converted? Refer to the introduction in this article. If you have a large amount of content that needs to be escaped, consider the mysql_real_escape_string function: mysql_real_escape_string-escapes the special characters in the string used in the SQL statement and takes into account the current character set of the connection. Note: This function does not escape% and _. In addition, it is best not to use the function for the entire SQL statement, but only to escape the string parameters of the incoming SQL statement, otherwise it will silently appear. Example: Test it in your own program to see how the escaped result is.

