mysql - 日期时间对象的 SQL 查询错误

Question

我正在尝试在我的 sql 数据库中执行此查询

'INSERT INTO ba_shop_opening (day, from, to) VALUES (?, ?, ?)' with params ["mon", "1970-01-01 00:00:00", "1970-01-01 00:00:00"]:

我收到以下错误

Syntax error or access violation: 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 'from, to) VALUES ('mon', '1970-01-01 00:00:00', '1970-01-01 00:00:00')' at line 1

这是我正在使用的表的 DDL

CREATE TABLE `ba_shop_opening` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from` datetime NOT NULL,
  `to` datetime NOT NULL,
  'day' VARCHAR(20) NOT NULL
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

我不明白这是什么问题。任何帮助将不胜感激。

Answer 1

from 是保留字。我建议您重命名表中的列。

https://dev.mysql.com/doc/refman/5.7/en/keywords.html