Hello sir,
In my application, all tables are fine. but now i wanna to add one more tables.
So i run the script is as follows:
CREATE TABLE tbl_lecture_question
(
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 (LQ_id
)
)
The table created successfully.
Now when i want to insert records in here it shows
INSERT INTO tbl_lecture_Question( lecture_id, Question, regDate )
VALUES (
‘24’, ‘Which is our national Bird?’, NOW( )
)
MySQL said:
#1146 - Table ‘jittzone_manasda.tbl_lecture_Question’ doesn’t exist
What is the problem ?
Why data is not inserting?