mysql - sql创建格式

Question

如何以一种可以工作并保持当前值的方式格式化以下 sql 文件；

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$$

当我尝试从我的 mac 终端创建它时出现以下错误

"'ERROR 1064 (42000) at line 3: 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) C' at line 1 "

Answer 1

用这个。 <强> Fiddler Demo

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;