The first line of error SQL-CodePudding

With mysql navicat runtime, always shows the first line of error, but I'm really not wrong, help bosses, thanks!

CodePudding user response:

 CREATE TABLE student 
(dept_name VARCHAR (20), 
Building a VARCHAR (15), 
PRIMARY KEY (dept_name) 
)

CodePudding user response:

The

reference 1/f, February 16 response:

 CREATE TABLE student 
(dept_name VARCHAR (20), 
Building a VARCHAR (15), 
PRIMARY KEY (dept_name) 
)

You mean the variable under the case,,,,?

CodePudding user response:

refer to the second floor in any less response:

Quote: reference 1/f, February 16 response:

CREATE TABLE student
(dept_name VARCHAR (20),
Building a VARCHAR (15),
PRIMARY KEY (dept_name)
)

You mean the variable under the case,,,,?

no, I am write and execute a success, why do wrong, you don't look well, if you can copy the code, should be able to have a look

CodePudding user response:

refer to February 16 reply: 3/f

Quote: refer to the second floor in any less response:

Quote: reference 1/f, February 16 response:

CREATE TABLE student
(dept_name VARCHAR (20),
Building a VARCHAR (15),
PRIMARY KEY (dept_name)
)

You mean the variable under the case,,,,?

no, I am write and execute a success, why do wrong, you don't look well, if you can copy the code, should be able to see

Oh oh thank you, but can't stick to class, and I of this code should be no problem, including case and symbol, tried many times, and then the original copy of the book, could you tell me could this be my software installation problem? I am a beginner mysql, installation seems to have a and vs2019 connection problem is not too good,

CodePudding user response:

reference 4 floor in any less response:

Quote: refer to the third floor of February 16 response:

Quote: refer to the second floor in any less response:

Quote: reference 1/f, February 16 response:

CREATE TABLE student
(dept_name VARCHAR (20),
Building a VARCHAR (15),
PRIMARY KEY (dept_name)
)

You mean the variable under the case,,,,?

no, I am write and execute a success, why do wrong, you don't look well, if you can copy the code, should be able to see

Oh oh thank you, but can't stick to class, and I of this code should be no problem, including case and symbol, tried many times, and then the original copy of the book, could you tell me could this be my software installation problem? I am a beginner mysql, installation seems to have a and vs2019 connection problem is not too good,

should not install problem, see a prompt SQL services should be no problem

CodePudding user response:

Dept_name varchar (20) primary key, to give it a try

CodePudding user response:

Or change to id int (4) primary key, so give it a try