MySQL Forums
Forum List  »  Newbie

table_name.table_name doesn't exist
Posted by: Regine Fontanilla
Date: March 17, 2017 11:15PM

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!

Options: ReplyQuote


Subject
Written By
Posted
table_name.table_name doesn't exist
March 17, 2017 11:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.