How do I insert a value in MySQL that consist of single or double quotes. i.e
This is Ashok’s Pen.
Put quite simply:
SELECT ‘This is Ashok’‘s Pen.’;
So inside the string, replace each single quote with two of them.
Or:
SELECT ‘This is Ashok’s Pen.’
参考
https://stackoverflow.com/questions/887036/how-to-escape-single-quotes-in-mysql