mysql - 我的代码在这里有什么不正确的地方？我不明白它有什么问题？

Question

[MOAT.GG] 查询错误：

您的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，以在第 1 行的“rank、first_join、last_join、avatar_url、playtime、inventory_credits、event_cred”附近使用正确的语法 |

带查询：

INSERT INTO player (steam_id, name, rank, first_join, last_join, avatar_url, playtime, inventory_credits, event_credits, donator_credits
) VALUES (
 ?, ?, NULL, UNIX_TIMESTAMP(), NULL, ?, 0, 0, 0, 0);
INSERT INTO player_iplog (SteamID, Address, LastSeen
) VALUES (
  ?, ?, UNIX_TIMESTAMP()
);
true

CREATE TABLE IF NOT EXISTS `player` (
    `steam_id` bigint(17) NOT NULL,
    `name` varchar(100) DEFAULT NULL,
    `rank` varchar(60) DEFAULT NULL,
    `first_join` int(10) DEFAULT NULL,
    `last_join` int(10) DEFAULT NULL,
    `avatar_url` varchar(150) DEFAULT NULL,
    `playtime` int(10) DEFAULT NULL,
    `inventory_credits` int(10) unsigned DEFAULT NULL,
    `event_credits` int(10) unsigned DEFAULT NULL,
    `donator_credits` int(10) unsigned DEFAULT NULL,
    `extra` varchar(150) DEFAULT NULL,
    `rank_expire` int(11) DEFAULT NULL,
    `rank_expire_to` varchar(32) DEFAULT NULL,
    `rank_changed` int(11) DEFAULT NULL,
    `mvp_access` int(11) DEFAULT NULL,
    PRIMARY KEY (`steam_id`),
    KEY `rank` (`rank`),
    KEY `inventory_credits` (`inventory_credits`),
    KEY `playtime` (`playtime`),
    KEY `last_join` (`last_join`),
    FULLTEXT KEY `name` (`name`)
);

标签： mysqlsql