Question

What are the different quote marks of MySQL?

Answer 1

SELECT "test", "'test'", "''test''", "te""st"; The output looks like this: Wrapping single quotes inside of double quotes will cancel out the expected behavior of the single quotes in the MySQL Query and instead treat it as part of the string. This can be seen in columns 2 and 3 in the example above.