create table table01(id int primary key,info varchar(128));

test.sql

update table01 set info='This is dyyx's cat' where id=1;
 
mysql> source test.sql;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's cat' where id=1' at line 1
 
update table01 set info='This is dyyx\'s cat' where id=1;
 
' 单引号 转义  \'