SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru ujjwal's Avatar
    Join Date
    Oct 2004
    Location
    kolkata
    Posts
    821
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql:Table is not exist though i am viewing table name?

    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?
    -::Ujjwal::-
    Visit My Site

  2. #2
    From space with love silver trophy
    SpacePhoenix's Avatar
    Join Date
    May 2007
    Location
    Poole, UK
    Posts
    5,072
    Mentioned
    103 Post(s)
    Tagged
    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.
    Community Team Advisor
    Forum Guidelines: Posting FAQ Signatures FAQ Self Promotion FAQ
    Help the Mods: What's Fluff? Report Fluff/Spam to a Moderator


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •