Problems with quotes in MySQL

Original: http://blog.csdn.net/wisgood/article/details/6317543

A string in MySQL that can be represented either in two single quotes or in two double quotes. For example, string Wangxiaowei, with single quotation marks for ' Wangxiaowei ', and double quotes for "Wangxiaowei"

When single quotation marks are used to denote a string, if single quotation marks appear in the string, two single quotation marks are used to denote a single quotation mark, as in the case of Wang ' Xiaowei, a single quotation mark is used to denote ' Wang ' Xiaowei '. When using double quotation marks to denote a string, if double quotation marks appear in the string, use two double quotation marks to denote a double quotation mark, such as Wang "Xiaowei, with double quotation marks for" Wang "" Xiaowei ".

For the following string, Wang "" Xiao ' Wei (Wang double quotes, double quotes, Xiao Single quotes Wei) can be represented either as single quotes or as double quotation marks.

Single quotes as ' Wang ', ' Xiao ' ' wei '

Explanation: Single quote Wang double quote double quote Xiaowei single quote Wei single quote

Double quotes as "Wang" "" "Xiao ' Wei"

Explanation: Double quotes Wang double quotes double quotes double quotes double quotes Xiaowei single quotes Wei double quotes

Problems with quotes in MySQL