Ansi Compatible: use single quote('), note double quote(").

-- the following are the same.
insert into jxtest (ttt) values('js''s test');
insert into jxtest (ttt) values('js\'s test');

Case Sensitivity in Names

Database, Table, Alias on Table are case sensitive.

If lower_case_table_names is 1 MySQL will convert all table names to lower case on storage and lookup. Note that if you change this option, you need to first convert your old table names to lower case before starting mysqld.