MySQL Forums
Forum List  »  Newbie

Insert command is failing
Posted by: David Clinton
Date: June 29, 2015 12:04PM

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,

Options: ReplyQuote


Subject
Written By
Posted
Insert command is failing
June 29, 2015 12:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.