insert single set of data multiple times mysql with dynamiv date

Question

I have to insert single set of data multiple times , say n rows.

INSERT INTO MyTable VALUES ("John", 123, "US");

Can I insert all n rows in a single SQL statement?

here n is dynamic value n is user input , how to make insert query n times , any idea.

$sql = "INSERT INTO `mytable` VALUES(`field1`,`field2`,`date`) VALUES ";
$count = 5;
for($i=0;$i<$coutn;$i++)
{
if($type=="daily")
{
  $st=date('Y-m-d H:i:s', strtotime('+1 day', strtotime('$st')));
}
else if($type=="monthly")
{
  $st=date('Y-m-d H:i:s', strtotime('+30 day', strtotime('$st')));
}

$sql .= " ('john','123','$st' )";
}

is this correct way..

tat too my question check my question first – Steve Bals Apr 23 '14 at 12:49 — Steve Bals, Apr 23 '14 at 12:49

score 0 · Answer 1 · answered Apr 23 '14 at 12:48

You can do it like:

$sql = "INSERT INTO `mytable` VALUES(`field1`,`field2`,`date`) VALUES ";
$count = 5;
$arr = array();
for($i=0;$i<$coutn;$i++)
{
if($type=="daily")
{
  $st=date('Y-m-d H:i:s', strtotime('+1 day', strtotime('$st')));
}
else if($type=="monthly")
{
  $st=date('Y-m-d H:i:s', strtotime('+30 day', strtotime('$st')));
}

$arr[] = " ('john','123','$st' )";
}
$sql .= implode(',', $arr);

insert single set of data multiple times mysql with dynamiv date

1 Answers1