CODEWITHSUNDEEP
mysqloracle-databaseinsert
Kumara
Kumara

Reputation: 127

how to insert mySQL command in a table row

When i use the following command: 

insert into history (id, command)  
values(2,'insert into show(id, moderator_ID, film_ID, time_length, adress, details) values(42,2,1,'123','123','123')');

It returns an error: missing comma. Why?

Upvotes: 0

Views: 57

Answers (2)

unknown
unknown

Reputation: 5017

Use double quote instead of single quote in second insert query

insert into history (id, command)  
values (2,'insert into show 
(id, moderator_ID, film_ID, time_length, adress, details) 
values (42,2,1,\"123\",\"123\",\"123\")');

Upvotes: 1

Jun Rikson
Jun Rikson

Reputation: 1884

Use double quote like this :

INSERT INTO `history` ( `id` , `command` )
VALUES ( '2', 'insert into show(id, moderator_ID, film_ID, time_length, adress, details) values(42,2,1,''123'',''123'',''123'')');

Upvotes: 0

Related Questions