**问题描述:**在mysql语句使用replace into 向表格中加入数据的时候报错
Error Code: 1064. 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 ‘‘dtime’,‘stationcode’,‘param’,‘valdata’) VALUES (‘2020-01-13 03:00:00’, ‘XY1291’’ at line 1
**解决方法:**查看mysql的帮助文件,语法和百度的不一样
官方:
REPLACE INTO test VALUES (1, 'New', '2014-08-20 18:47:42');
百度的结果:
REPLACE INTO t_test (`name`)VALUES('a')