我想使用PHP和MysqL来插入昨天的日子.所以我的想法是:
INTO chartValues SET timestamp='1353369600',`datetime`=DATEADD(d,-1,GETDATE())
但它不起作用:
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 ‘INTO chartValues SET timestamp=’1353369600’,
datetime
=DATEADD(d,GETDATE())’ at line 1
提前致谢
最佳答案