How to Insert Commas & Quotes in MySQL. Special characters require the MySQL escape character to indicate to the server that you want to insert the characters without executing any secondary code.

Insert your string into the MySQL table with the syntax "INSERT INTO MySQL-Table (String-Column) VALUES ('String');" where "String-Column" is the name of the column in the table that holds text ...

The following discussion first discusses how MySQL handles improper data by default, and then covers the changes that occur when you enable the various SQL modes that affect data handling.