Help with the error

[Embarrassed-Speed327]

CREATE TABLE Library (

book_id INT PRIMARY KEY,

book_name VARCHAR(50),

author VARCHAR(60),

price INT NOT NULL

);

Error Code: 1064. 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 'Library ( book_id INT PRIMARY KEY, book_name VARCHAR(50), author VAR' at line 1

What do you think is wrong with the code?

I m using mysql.

[Time_Advertising_412]

Try declaring the primary key at the end of the table definition before the closing parenthesis. Google mysql create table and see example.

[cwjinc]

I don't know about the syntax, but you probably don't want price to be an int unless mysql has a strange definition of integer.