mysql 插入带引号

INSERT INTO table_name (column_name) VALUES ('This is a string with a single quote '' inside.');

INSERT INTO table_name (column_name) VALUES ("This is a string with a single quote ' inside.");

INSERT INTO table_name (column_name) VALUES ('This is a string with double quotes " inside.');

INSERT INTO `table_name` (`column_name`) VALUES ('This is a string with backticks ` inside.');

-- 插入带单引号的数据
INSERT INTO users (name, bio) VALUES ('John Doe', 'He said, ''Hello, world!''');

-- 插入带双引号的数据（在某些情况下）
INSERT INTO users (name, bio) VALUES ("John Doe", "He said, \"Hello, world!\"");

-- 插入带反引号的数据
INSERT INTO `users` (`name`, `bio`) VALUES ('John Doe', 'He said, `Hello, world!`');