MySQL的脚本语法错误

问题描述：

我得到一个语法错误试图运行MySQL的这个脚本并不能弄清它是错误的。任何帮助，将不胜感激。下面是代码：MySQL的脚本语法错误

SHOW DATABASES; 

DROP DATABASE IF EXISTS conman; 

Create Database conman; 

USE conman; 

CREATE TABLE contact_info(

firstname varchar(25), 
middleinitial char(1), 
lastname varchar(25), 
suffix_description varchar(5), 
title_description varchar(5), 
jobtitle varchar(40), 
department varchar(30), 
email varchar(35), 
url varchar(50), 
IMaddress varchar(25), 
phone_number varchar(25), 
phonetype_description varchar(10), 
birthday date, 
notes varchar(255), 
companyname varchar(30), 
addressLine1 varchar(40), 
addressLine2 varchar(45), 
city varchar(25), 
state_province varchar(20), 
zip_postalcode varchar(10), 
country_region varchar(15), 
companyURL varchar(45), 
companyPhone varchar(12), 
); 

INSERT INTO contact_info 
(
firstName, 
middleInitial, 
lastName, 
suffixDescription, 
titleDescription, 
jobTitle, 
department, 
email, 
url, 
IMaddress, 
phoneNumber, 
phoneDescription, 
birthday, 
notes, 
companyName, 
addressLine1, 
addressLine2, 
city, 
state_province, 
zip_postalcode, 
country_region, 
companyURL, 
companyPhone, 
) 
VALUES 
(
'Jacob', 
'P', 
'Jacobson', 
'Jr', 
'Mr', 
'Director', 
'Finance', 
'[email protected]', 
'www.concor.com/~rjames', 
'jpjacobson', 
'323-546-6834', 
'work', 
'1969-07-13', 
'All meetings must be scheduled through Charlene Renolds', 
'Concor International, Inc.', 
'143 South Main Street', 
'', 
'Los Angeles', 
'CA', 
'90012-3712', 
'USA', 
'www.concor.com', 
'323-546-6834', 
)

，这里是错误消息：

ERROR 1064（42000）：你在你的SQL语法错误;检查对应于你的MySQL服务器版本在第26行

ERROR 1064（42000）使用近“）”正确的语法手册：您有一个错误的SQL语法;检查对应于你的MySQL服务器版本正确的语法使用附近的手册“ VALUES）（ ‘雅’， ‘P’， ‘雅各布森’， ‘JR’， ‘先生’， ”导演”， '财经'， 'rjameso' 在第26行

后'删除逗号公司电话VARCHAR（12），'的'创建table'和'公司电话，后面的逗号'的'insert'声明 –

你的最后一个值后也逗号。 – Mihai

非常感谢，我一直在寻找这个太久以至于无法注意到这一点。多谢你们！ –

答

您CREATE TABLE中的每一个，INSERT INTO删除最后一个逗号和VALUES语句：

SHOW DATABASES; 

DROP DATABASE IF EXISTS conman; 

Create Database conman; 

USE conman; 

CREATE TABLE contact_info(

firstname varchar(25), 
middleinitial char(1), 
lastname varchar(25), 
suffix_description varchar(5), 
title_description varchar(5), 
jobtitle varchar(40), 
department varchar(30), 
email varchar(35), 
url varchar(50), 
IMaddress varchar(25), 
phone_number varchar(25), 
phonetype_description varchar(10), 
birthday date, 
notes varchar(255), 
companyname varchar(30), 
addressLine1 varchar(40), 
addressLine2 varchar(45), 
city varchar(25), 
state_province varchar(20), 
zip_postalcode varchar(10), 
country_region varchar(15), 
companyURL varchar(45), 
companyPhone varchar(12) 
); 

INSERT INTO contact_info 
(
firstName, 
middleInitial, 
lastName, 
suffixDescription, 
titleDescription, 
jobTitle, 
department, 
email, 
url, 
IMaddress, 
phoneNumber, 
phoneDescription, 
birthday, 
notes, 
companyName, 
addressLine1, 
addressLine2, 
city, 
state_province, 
zip_postalcode, 
country_region, 
companyURL, 
companyPhone 
) 
VALUES 
(
'Jacob', 
'P', 
'Jacobson', 
'Jr', 
'Mr', 
'Director', 
'Finance', 
'[email protected]', 
'www.concor.com/~rjames', 
'jpjacobson', 
'323-546-6834', 
'work', 
'1969-07-13', 
'All meetings must be scheduled through Charlene Renolds', 
'Concor International, Inc.', 
'143 South Main Street', 
'', 
'Los Angeles', 
'CA', 
'90012-3712', 
'USA', 
'www.concor.com', 
'323-546-6834' 
)

MySQL的脚本语法错误

相关推荐