locked
MySQL Command Line will not insert into a table. RRS feed

  • Question

  • Hi.

    I am literally about to tear my hair out, I've never used sql before but I cannot figure out whats wrong with my code.  I'm just going to describe everything I do:

    Open MySQL 5.5 Command Line Client

    Enter password: password

    mysql>use databaseName;

    mysql>show tables;

    Tables_in_databasename

    mapdata

    1 row in set (0..00 sec)

    mysql>describe mapdata;

    Field                         Type         Null  Key  Default  Extra

    mapID               varchar(255)   YES           NULL 

    iconLocation      varchar(255)   YES           NULL

    mapDescription varchar(1000) YES           NULL

    3 rows in set (0.01 sec)

    mysql>insert into mapdata values ("map1name","c:/bla_bla_path", "Neat Map");

    Query OK, 1 row affected (0.00 sec)

    mysql>describe mapdata;

    Field                         Type         Null  Key  Default  Extra

    mapID               varchar(255)   YES           NULL 

    iconLocation      varchar(255)   YES           NULL

    mapDescription varchar(1000) YES           NULL

    3 rows in set (0.01 sec)

    mysql>show keys from mapdata;

    Empty set (0.00 sec)

    I cannot for the life of me figure out why nothing is being stored.  Is the table somehow uneditable? Are things somehow being stored and I'm just not looking correctly? Am I somehow failing to save the changes? Any help would be greatly appreciated.  



    • Edited by dndeed Thursday, August 22, 2013 7:51 PM
    • Moved by Anna Cc Friday, August 23, 2013 3:19 AM
    Thursday, August 22, 2013 7:45 PM

All replies

  • You should start with visiting the forums on forums.mysql.com. It is their product, they know better.


    Visual C++ MVP

    Thursday, August 22, 2013 10:09 PM
  • Hi dndeed,

    Thank you for posting in MSDN Forum.

    However, your issue is more related with  MySQL.

    I suggest you post your issue there. Here i paste the link : http://forums.mysql.com/.

    Thanks for your understanding.


    Sunny Cao
    <THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>
    Thanks
    MSDN Community Support

    Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.

    Friday, August 23, 2013 3:18 AM