MySQL : Insert Exactly Same Data Multiple Rows Without PHP Loop

Question

I need to insert same data to my MySQL table without having PHP loop. The reason why I'm doing this is that because I have a column with Auto_Increment feature and that column associates with other table.

So, I just need to insert some exactly same data and it's multiple rows (dynamic) but by using single INSERT syntax below :

INSERT INTO outbox_multipart (TextDecoded) VALUES ('$SMSMessage')

how to have this single INSERT syntax, but produce n number of rows?

how to do it? example please..

Saint Robson
– Saint Robson

2012-09-27 15:30:33 +00:00
Commented Sep 27, 2012 at 15:30 — Saint Robson
– Saint Robson, Commented Sep 27, 2012 at 15:30

Mahmoud Gamal · Accepted Answer · 2012-09-27 15:49:08Z

2

You can do this:

INSERT INTO outbox_multipart (TextDecoded) VALUES ('$SMSMessage')
, ('$SMSMessage2'), ('$SMSMessage3'), ('$SMSMessage4');

edited Sep 27, 2012 at 15:49

answered Sep 27, 2012 at 15:28

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Teena Thomas Over a year ago

SMSMessage2 is a variable, not a string.

Teena Thomas Over a year ago

he mentioned its the same data i.e. a string in variable $SMSMessage

Mahmoud Gamal Over a year ago

@coder1984 I agree with you, but the OP wasn't clear in this, he didn't say a variable. It was just the $SMSMessage in the statement he wrote. So I did what he asked fore which is how to have this single INSERT syntax, but produce n number of rows

Teena Thomas Over a year ago

if u dont consider it to be a variable, then you condsider it to be a string, which again would be '$SMSMessage', $ being considered as a char, as per his question. you changed it to SMSMessage

Teena Thomas Over a year ago

its just an observation, thats all :)

|

Moe Tsao · Accepted Answer · 2012-09-27 15:33:46Z

0

INSERT INTO outbox_multipart (TextDecoded) VALUES ('$SMSMessage'),('$SMSMessage')
,('$SMSMessage'),('$SMSMessage')

if done dynamically,

$n=5;
for ($i=0;$i<$n;$i++){$values.="('$SMSMessage'),";}
$values=substr($values,0,-1);

And the SQL be:

INSERT INTO outbox_multipart (TextDecoded) VALUES $values

edited Sep 27, 2012 at 15:33

answered Sep 27, 2012 at 15:28

Moe Tsao

1,0546 silver badges9 bronze badges

Comments

faq · Accepted Answer · 2012-09-27 15:37:35Z

0

mysql_query("INSERT INTO `table`(`this`) VALUES (`that`); INSERT INTO `table`(`this`) VALUES (`that`);");

answered Sep 27, 2012 at 15:37

faq

3,1465 gold badges29 silver badges37 bronze badges

Comments

Teena Thomas · Accepted Answer · 2012-09-27 15:53:50Z

0

try something like this

     $sql = mysql_query("INSERT INTO outbox_multipart (TextDecoded) VALUES ('$SMSMessage')
      , ('$SMSMessage'),('$SMSMessage'),('$SMSMessage')");

Also, just so you know, mysql_* have been deprecated. So, try to use mysqli_* or PDO for querying.

edited Sep 27, 2012 at 15:53

answered Sep 27, 2012 at 15:30

Teena Thomas

5,2091 gold badge15 silver badges17 bronze badges

Comments

Marcin Nabiałek · Accepted Answer · 2014-10-27 09:55:27Z

0

suppose you want 3 insertions simply do like this:

INSERT INTO outbox_multipart (TextDecoded) VALUES ('$SMSMessage'),('$SMSMessage'),('$SMSMessage');

edited Oct 27, 2014 at 9:55

Marcin Nabiałek

112k43 gold badges271 silver badges299 bronze badges

answered Oct 27, 2014 at 9:34

Sandeep Gantait

89510 silver badges9 bronze badges

Collectives™ on Stack Overflow

MySQL : Insert Exactly Same Data Multiple Rows Without PHP Loop

5 Answers 5

6 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

6 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related