u/Embarrassed-Speed327

▲ 2 r/learnSQL+1 crossposts

Help with the error

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.

reddit.com
u/Embarrassed-Speed327 — 6 days ago