Results 1 to 2 of 2
Mar 21, 2010, 23:54 #1
Mysql:Table is not exist though i am viewing table name?
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 )
'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?-::Ujjwal::-
Visit My Site
Mar 22, 2010, 00:01 #2
- Join Date
- May 2007
- Poole, UK
- 80 Post(s)
- 0 Thread(s)
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.