table_name.table_name doesn't exist
I am makign a databse for my project but i cant save it on phpmyadmin demo site
this is the instruction for my project:
a. Create the main database
b. Create the tables needed for the database
c. Create new entries for all the tables
d. Update entries for all the tables
e. Delete entries for all the tables
f. Useful commands for searching
these are the queries i made:
SELECT * FROM Professors where 1;
CREATE TABLE Professors (id INTEGER, name TEXT, course TEXT);
INSERT INTO Professors (id, name, course)
VALUES (1, 'Lubrica, Marie Anjeli', MMS 144);
SELECT * FROM Professors;
INSERT INTO Professors (id, name, course)
VALUES (2, 'Tan, Katrina Ross', MMS 121);
INSERT INTO Professors (id, name, course)
VALUES (3, 'De Jesus, Rameses', COMM 3);
update Professors
set course = COMM 2
where id = 3;
select * from Professors;
alter table Professors add column user_name text;
update Professors
set user_name =’ DJ Rameses’
where id = 3;
DELETE FROM Professors WHERE user_name IS NULL;
select * from Professors;
select*from Professors;
DELETE FROM Professors WHERE user_name IS NULL;
these lines keep appearing "SQL query: Documentation
"SELECT * FROM Professors where 1 LIMIT 0, 25"
"#1146 - Table 'Professors.Professors' doesn't exist"
I dont know what to do anymore. it's due for submission tomorrow. PLEASE Help me guys!