MySQL Command Line will not insert into a table.

• Question

• 

  

  0

  Sign in to vote

  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