Insert command is failing
I'm fairly new to MySQL and I've working from the MySQL command line (I'm using Server version: 5.5.43-0ubuntu0.14.04.1 (Ubuntu), by the way).
I'm trying to create and insert data into a table using:
create table complaints (date DATE, email VARCHAR(20), message VARCHAR(250), response VARCHAR(250));
and
insert into complaints (date,email,message,response) values ('2015-07-05','joe@cranky.com','your product stinks','so what?');
These both work. But when I try to insert another record it will *sometimes* fail, dumping me on to the second line. Here's an example:
mysql> insert into complaints (date,email,message,response) values ('2015-09-03','tony@gmail.com','Where's my money?','What money?');
'>
Does anyone know what I'm doing wrong? Also,is there any way to abort the command besides ctrl-c?
Thanks,