Need help fast in MySQL

butchermanj

New Member
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 " '> "
 

zkiller

Super Moderator
Staff member
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.
 

butchermanj

New Member
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
 

zkiller

Super Moderator
Staff member
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.
 
Top