SQL语句出现问题?!!!在线急求大神解答!!
YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfo...
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 'student' at line 1。
SQL语句如下:
drop database if exists student;
create database student;
use student;
CREATE TABLE stu_table(stu_no char(10), stu_name char (10), class char(10));
INSERT INTO stu_table VALUES('001', 'Tom', '1');
INSERT INTO stu_table VALUES('002', 'Peter', '3');
INSERT INTO stu_table VALUES('003', 'Mike', '2'); 展开
SQL语句如下:
drop database if exists student;
create database student;
use student;
CREATE TABLE stu_table(stu_no char(10), stu_name char (10), class char(10));
INSERT INTO stu_table VALUES('001', 'Tom', '1');
INSERT INTO stu_table VALUES('002', 'Peter', '3');
INSERT INTO stu_table VALUES('003', 'Mike', '2'); 展开
1个回答
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询