未曾仰望的星空 2020-12-26 22:25 采纳率: 0%
浏览 116

有一个SQL文件,打开有这个错误,具体的代码如下,请求大佬解答下,找不出错误?

错误为"SELECT" is not valid at this position,expecting: EOF, ';'

 

代码如下:

USE address  

SELECT name,phone1 FROM dbo.Addressbook

CREATE TABLE Addressbook(     

id INT PRIMARY KEY IDENTITY,   

name VARCHAR(10),   

phone1 VARCHAR(15), 

phone2 VARCHAR(15)

 )

USE addresslist

SELECT *FROM dbo.Addressbook  

 

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('梁朝伟', '16667966666', '15688996423');

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('周星驰', '19967998888', '13788996629');  

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('张曼玉', '11267996252', '15789496250');

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('陈奕迅', '18767996252', '19788799682');

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('张国荣', '18867996252', '15687996224');  

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('周慧敏', '18267996252', '15767996923');

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('张国荣', '18967996252', '16777996225');  

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('陈柏宇', '18867996252', '15777996320');

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('周柏豪', '18566725532', '16666996253');  

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('杨千嬅', '18867277993', '15799625625');    

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('某某惠', '18267996252', '15767996923');

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('梁静茹', '18967996252', '16777996225');

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('林宥嘉', '18867996252', '15777996320');  

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('刘瑞琦', '18566725532', '16666996253');

INSERT dbo.Addressbook(name,phone1,phone2)VALUES('孙燕姿', '18867277993', '15799625625');

  • 写回答

2条回答 默认 最新

  • jixl0224 2020-12-27 08:52
    关注

    每行结束,不需要添加分号吗?

    评论

报告相同问题?