字符串
mysql> SELECT "hello", "'hello'", "''hello''", "hel""lo", "\"hello";
+-------+---------+-----------+--------+--------+
| hello | 'hello' | ''hello'' | hel"lo | "hello |
+-------+---------+-----------+--------+--------+
| hello | 'hello' | ''hello'' | hel"lo | "hello |
+-------+---------+-----------+--------+--------+
1 row in set (0.01 sec)
mysql> SELECT 'This\nIs\nFour\nLines';
+--------------------+
| This
Is
Four
Lines |
+--------------------+
| This
Is
Four
Lines |
+--------------------+
1 row in set (0.00 sec)
mysql> SELECT 'This\nIs\nFour\nLines' line;
+--------------------+
| line |
+--------------------+
| This
Is
Four
Lines |
+--------------------+
1 row in set (0.01 sec)
mysql> SELECT 'disappearing\ backslash';
+------------------------+
| disappearing backslash |
+------------------------+
| disappearing backslash |
+------------------------+
1 row in set (0.01 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22664653/viewspace-683135/ ，如需转载，请注明出处，否则将追究法律责任。
