mysql> create table tx (x varchar(100);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql> create table tx (x varchar(100));
Query OK, 0 rows affected, 2 warnings (0.04 sec)
mysql> insert into tx values ('vidi me "mama"');
Query OK, 1 row affected (0.00 sec)
mysql> insert into tx values ("vidi me ""mama""");
Query OK, 1 row affected (0.00 sec)
mysql> insert into tx values ("vidi me \"mama\"");
Query OK, 1 row affected (0.00 sec)
mysql> select * from tx;
+----------------+
| x |
+----------------+
| o'conors |
| o'conors |
| vidi me "mama" |
| vidi me "mama" |
| vidi me "mama" |
+----------------+
5 rows in set (0.00 sec)