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

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

Re: After a syntax error: I get thid odd Prompt and can"t enter anymore commands.

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.