Need help fast in MySQL

Discussion in 'Programming' started by butchermanj, Oct 8, 2007.

to remove all ads.
  1. butchermanj

    butchermanj New Member

    Messages:
    16
    I am using MySQL and I entered:

    mysql>insert into categories (parent_id, name, description)
    ->values (13, 'Americana', 'A patriot's treasure chest - full of wonderful ways to show your spirit!');

    but instead of the "syntax", i guess you call it, closing - i got:

    '>

    How do I get it back to enter more syntax....

    mysql>
    ^
    How do I get that back

    When I enter text in the " '> " nothing happens it just keeps repeating " '> "
     
  2. zkiller

    zkiller Super Moderator Staff Member

    Messages:
    1,639
    have you tried restarting the mysql server?

    to be perfectly honest, i don't have a lot of experience with mysql or the linux command line. have you tried posting in the official mysql forums?

    http://forums.mysql.com/

    checking the mysql documentation might also be worth a shot.

    http://dev.mysql.com/doc/

    sorry i couldn't be of more help.
     
  3. butchermanj

    butchermanj New Member

    Messages:
    16
    if i restart mysql will i lose my data already entered?
     
  4. zkiller

    zkiller Super Moderator Staff Member

    Messages:
    1,639
    this should not affect any data that is in the database already.
     
  5. butchermanj

    butchermanj New Member

    Messages:
    16
    hey i figured it out

    mysql>insert into categories (parent_id, name, description)
    ->values (13, 'Americana', 'A patriot's treasure chest - full of wonderful ways to show your spirit!'); ^

    the apostrophe in patriot's acted as a single quote and the syntax didn't read another single quote to end the syntax
     
  6. zkiller

    zkiller Super Moderator Staff Member

    Messages:
    1,639
    i figured that was what caused it, but i was more concerned about you being unable to access the mysql database anymore. glad you solved the problem.
     

Share This Page