[Rocket_Girl39]

PLEASE HELP

I am taking database management I am a newbie, and I was inserting commands into my tables, well on the last bit of information I hit I think enter and it wont let me input anymore information. I am getting this symbol '> instead of this symbol ->

[modi123_1]

What? Explain what system you are using, where you are, etc...

[Atli]

When the MySQL console client shows you a '> prompt, it means that whatever you typed on the previous line opened a string but failed to close it. Everything you are typing, until the string is closed, will be read as a part of that open string value.

You most likely forgot the closing ' for a string value in the previous line.

[Rocket_Girl39]

So how do you close it, when the string is opened? Thank you.

[Atli]

By typing the closing ' char. For instance:

mysql> SELECT thedata FROM whatever
    -> WHERE field1 = 'something'
    -> AND   field2 = 'something
    '> else entirely'
    -> AND   field3 = 42;

On the third line there I open a string but do not close it, so the next line has a '> prompt telling me that it's still reading input for that string. To close it I just type the closing ' char. You can see that the string is closed by the -> prompt on the line after that.