在PhpMyAdmin中创建表-错误1064 [英] Creating tables in PhpMyAdmin - error 1064

问题描述

代码:

            delimiter $$

            CREATE TABLE "login" (
              "IdUser" int(11) NOT NULL AUTO_INCREMENT,
              "username" varchar(45) CHARACTER SET latin1 NOT NULL,
              "pass" varchar(45) CHARACTER SET latin1 NOT NULL,
              PRIMARY KEY ("IdUser")
            ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8$$

            CREATE TABLE "photos" (
              "IdPhoto" int(11) NOT NULL AUTO_INCREMENT,
              "title" varchar(100) CHARACTER SET latin1 NOT NULL,
              "IdUser" int(11) NOT NULL,
              PRIMARY KEY ("IdPhoto")
            ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8$$

错误:

#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 '"login" (
  "IdUser" int(11) NOT NULL AUTO_INCREMENT,
  "username" varchar(45)' at line 1 

#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 '"photos" ( "IdPhoto" int(11) NOT NULL AUTO_INCREMENT, "title" varchar(100)' at line 1

有什么想法吗?我对此是全新的，所以我们将不胜感激.

Any ideas? I'm brand new to this so any help would be very much appreciated.

推荐答案

仅当

You can use double quotes in identifiers only if the ANSI_QUOTES SQL mode is enabled.

SET sql_mode='ANSI_QUOTES';

这里是 SQLFiddle 演示

Here is SQLFiddle demo

否则，如果您的标识符不在保留字列表中，则只需使用反勾号或什么都不用.

Otherwise just use back ticks or nothing at all if your identifiers are not in a reserved words list.

CREATE TABLE `login` (
  `IdUser` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(45) CHARACTER SET latin1 NOT NULL,
  `pass` varchar(45) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`IdUser`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
;

CREATE TABLE `photos` (
  `IdPhoto` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET latin1 NOT NULL,
  `IdUser` int(11) NOT NULL,
  PRIMARY KEY (`IdPhoto`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
;

这里是 SQLFiddle 演示

Here is SQLFiddle demo

进一步阅读架构对象名称

这篇关于在PhpMyAdmin中创建表-错误1064的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！