So I was trying to create a library query as my project in SQL (MySql Workbench) and I have this code below
CREATE TABLE library (
book VARCHAR(100),
author VARCHAR(200),
section INT,
PRIMARY KEY(section)
);
INSERT INTO library VALUES('The Owl','Mr ochwitch',3);
INSERT INTO library VALUES('Austrian','Wolfgang',7);
SELECT * FROM library WHERE section = 3;
SELECT * FROM library;
where I’m trying to select a book on section ‘3’ and expected
book author section
'Austrian' 'Woflgang' 3
as my output but I got
16:03:47 SELECT * FROM library WHERE section = 3 LIMIT 0, 1000 Error Code: 1054. Unknown column 'section' in 'where clause' 0.000 sec
error instead. Please help