php - Mysql同一行复制同一张表120次

Question

简单的mysql表:

CREATE TABLE  `users` (
 `id` INT NOT NULL AUTO_INCREMENT ,
 `name` TEXT NOT NULL ,
 `surname` text NOT NULL ,
 `city` text NOT NULL ,
PRIMARY KEY (  `id` )
) ENGINE = MYISAM

然后像这样插入:

INSERT INTO `users` (`id`, `name`, `surname`, `city`) VALUES (1,`rock`,`fixed`,`london`);

如何使用不同的主 ID 输入同一行的同一表详细信息 100 次？

Answer 1

使用 php 你可以这样做:

for($i=0; $i< 119; $i++)
{
     //execute your query here, do not include your id column
     INSERT INTO `users` (`name`, `surname`, `city`)   
     VALUES   (`rock`,`fixed`,`london`);
 }  

或
您也可以使用 mysql 存储过程来完成此操作，例如:

//Loop stored procedure

DELIMITER $$
DROP PROCEDURE IF EXISTS test$$
CREATE PROCEDURE test()
BEGIN
 DECLARE count INT DEFAULT 0;
 WHILE count < 119 DO
      INSERT INTO `users` (`name`, `surname`, `city`)   
      VALUES   (`rock`,`fixed`,`london`);
   SET count = count + 1;
 END WHILE;
END$$
DELIMITER ;

execute the stored procedure

call test();

根据评论进行编辑:
您的代码无法正常工作，因为您正在循环“外部”执行查询，您的代码应如下所示:

<?php 

*/here mysql connection 
for($x=0; $x<100; $x++) 
{ 
   $sql =INSERT INTO users (name, surname, city) 
          VALUES (rock,fixed,london); 
   $status = $conn->query($sql);
} 

if ($status) 
{  echo "New record created successfully"; }
else { echo "Error: " . $sql . "<br>" . $conn->error; } 
$conn->close(); 
?>