Question

With this code:

CREATE TABLE STUDENT(
StudentID integer, primary key
StudentName char(25) NOT NULL)

I am getting the 1064 error about char(25) but don't know how to fix it in MySQL workbench.

Answer 1

Answer-

CREATE TABLE STUDENT(StudentID integer, primary key StudentName char(25) NOT NULL)

• Here you wrote incorrect primary key attribute that show missing left parenthesis error.

​​​​​​​The correct Query-

CREATE TABLE STUDENT(StudentID integer, StudentName char(25) NOT NULL,primary key(StudentName))

Note- Please do upvote, if any problem then comment in box sure I will help.