Ways to resolve mysql #1064 error in the following code?

Question

I tried using EVERSQL to validate the following code but its also showing error

You have an error in your SQL syntax; it seems the error is around: 'NOT NULL, DepartmentID int NOT NULL, CategoryID int NOT NULL, CourseName V' at line 2

this is my SQL query,

CREATE TABLE Course (
    CourseID varchar NOT NULL,
    deptID int NOT NULL,
    catID int NOT NULL,
    CourseName Varchar NOT NULL,
    Credit varchar NOT NULL,
    PRIMARY KEY (CourseID),
    FOREIGN KEY (deptID) REFERENCES department(deptID),
    FOREIGN KEY (catID) REFERENCES coursecategory(catID)
);

and this is the error I'm getting

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL,
    deptID int NOT NULL,
    catID int NOT NULL,
    CourseName ...' at line 2

Does this answer your question? [How can I fix MySQL error #1064?](https://stackoverflow.com/questions/23515347/how-can-i-fix-mysql-error-1064) — Dharman, Jul 01 '21 at 11:45

score 0 · Answer 1 · answered Jul 01 '21 at 11:48

You need to specify the lengths of your varchar columns. E.g.:

CREATE TABLE Course (
    CourseID varchar(10) NOT NULL,
    deptID int NOT NULL,
    catID int NOT NULL,
    CourseName varchar(10) NOT NULL,
    Credit varchar(10) NOT NULL,
    PRIMARY KEY (CourseID),
    FOREIGN KEY (deptID) REFERENCES department(deptID),
    FOREIGN KEY (catID) REFERENCES coursecategory(catID)
);

Ways to resolve mysql #1064 error in the following code?

1 Answers1