After a syntax error: I get thid odd Prompt and can't enter any more commands.

[Greg Noss]

My trying to paste CSV data into my dataBase sometimes the pasted data
creates errors. After that my prompt looks like this: "> then I'm not
able to enter any commands, the "> prompt keeps repeating every time I hit
"enter" I have to shut the window and restart MySQL.

Thanks,

Greg Noss

[Bill Karwin]

Greg Noss wrote:

My trying to paste CSV data into my dataBase sometimes the pasted data
creates errors. After that my prompt looks like this: "> then I'm not
able to enter any commands, the "> prompt keeps repeating every time I hit
"enter" I have to shut the window and restart MySQL.

You don't have a semicolon terminating the statement(s) in your pasted data.

I often forget the semicolon, and have to type it on the next line:

mysql> select * from table
-> ;

If you're importing raw CSV data, you might find it easier to use the
LOAD DATA INFILE statement, instead of copy & paste.
http://dev.mysql.com/doc/refman/5.0/en/load-data.html

Regards,
Bill K.