Truncated incorrect DOUBLE value错误

分类: IT文章 • 2024-04-17 22:16:47

mysql报错:Truncated incorrect DOUBLE value

sql的update语法错误
eg:
update Person set name = ‘auhnayuiL’ and age = 1 where id = 1;
改and为,
update Person set name = ‘auhnayuiL’ , age = 1 where id = 1;