In my application, all tables are fine. but now i wanna to add one more tables.
So i run the script is as follows:
LQ_id bigint(20) NOT NULL auto_increment,
lecture_id bigint(20) NOT NULL,
Question varchar(500) NOT NULL,
regDate datetime NOT NULL,
PRIMARY KEY (
The table created successfully.
Now when i want to insert records in here it shows
INSERT INTO tbl_lecture_Question( lecture_id, Question, regDate )
'24', 'Which is our national Bird?', NOW( )
1146 - Table 'jittzone_manasda.tbl_lecture_Question' doesn't exist
What is the problem ?
Why data is not inserting?
Just a typo your table is called tbl_lecture_question and your query is trying to insert the data into a table called tbl_lecture_Question which it can't find. Table names are case-sensitive.