Mysql代码出现1064错误 - Error 1064 in Mysql code

Error 1064 in Mysql code

本文关键字：1064 错误代码 Mysql | 更新日期: 2023-09-26

CREATE TABLE IF NOT EXISTS `apayments` (
  `id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `payment_hash` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `towho` varchar(128) NOT NULL,
  `money` enum('Pay','Ask') NOT NULL DEFAULT 'Pay',
  `type` enum('email','text') NOT NULL DEFAULT 'email',
       ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

去掉email附近的逗号

CREATE TABLE IF NOT EXISTS `apayments` (
  `id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `payment_hash` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `towho` varchar(128) NOT NULL,
  `money` enum('Pay','Ask') NOT NULL DEFAULT 'Pay',
  `type` enum('email','text') NOT NULL DEFAULT 'email'
                                                    ^^^^^^
       ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

错误显示，因为电子邮件有逗号尝试执行这个命令

CREATE TABLE IF NOT EXISTS `apayments` (
  `id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  `payment_hash` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `towho` varchar(128) NOT NULL,
  `money` enum('Pay','Ask') NOT NULL DEFAULT 'Pay',
  `type` enum('email','text') NOT NULL DEFAULT 'email'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;