Need to insert same record multiple times

[Evangogh]

Hello, all.

I would like to insert the same record into a MySql table 100 times, and was wondering how I could do that. I know it must be possible with a loop, but I don't know how to construct it, as I am just learning MySql.

Thanks in advance for any tips!

[itbeings]

What script do you want to use in inserting this records? PHP?

[Evangogh]

Sorry about that - yes, I am using PHP.

Thanks!

[chazzy]

the easiest way is to build a multiple insert query.


$sql = "INSERT INTO table(column_list) VALUES";
$max = 100;
for($i=1;$i<=100;i++){
$sql .= "(values)";
if($i != $max)
$sql .= ","
}
echo $sql;

http://dev.mysql.com/doc/refman/5.0/en/insert.html

[Evangogh]

Just what I needed - thanks!