SQL query to insert muliple records with different email address

[kevinkhan]

Hi guys.

 

I have the following query

 

INSERT INTO `cork_wall`.`Classified` (
`id` ,
`user` ,
`description` ,
`link` ,
`img1` ,
`published`
)
VALUES (
NULL , 'corkdjs@gmail.com', 'Hi guys.', '', 'http://munsterweddingdjs.com/images/weddings-in-east-cork.jpg', '0'
);

 

how do i insert the same record multiple times but changing the email address each time to the following emails...

 

email1@hotmail.com

email2@hotmail.com

email3@hotmail.com etc

 

is there any quick way of doing it besides writhing out a different query for each email address?

[joel24]

just enclose the values with brackets and seperate with a comma

INSERT INTO `cork_wall`.`Classified` (
`id` ,
`user` ,
`description` ,
`link` ,
`img1` ,
`published`
)
VALUES (NULL , 'corkdjs@gmail.com', 'Hi guys.', '', 'http://munsterweddingdjs.com/images/weddings-in-east-cork.jpg', '0'),
(NULL , 'email2@gmail.com', 'Hi guys.', '', 'http://munsterweddingdjs.com/images/weddings-in-east-cork.jpg', '0'),
(NULL , 'email3@gmail.com', 'Hi guys.', '', 'http://munsterweddingdjs.com/images/weddings-in-east-cork.jpg', '0');