<?php
$servername = "127.0.0.1";
$username = "root";
$password = "root";
$dbname = "test";
$n = 10000; //每次生成的数据量
$k = 2000; //循环的次数
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
ini_set('memory_limit','1008M');
set_time_limit(0);
$name = '赵钱孙李周吴郑王冯陈褚卫蒋沈韩杨朱秦尤许何吕施张孔曹严华金魏陶姜戚谢邹喻柏水窦章云苏潘葛奚范彭郎鲁韦昌马苗凤花方俞任袁柳酆鲍史唐钟徐邱骆高夏蔡田樊胡凌霍';
$strlen = mb_strlen($name);
$rand_max = $strlen-1;
$sql = '';
for($s=0;$s<$k;$s++){
$sql = "INSERT INTO user (name, age, city) VALUES";
for($i=0;$i<$n;$i++){
$s_name = mb_substr($name,mt_rand(0,$rand_max),1).mb_substr($name,mt_rand(0,$rand_max),1).mb_substr($name,mt_rand(0,$rand_max),1);
$age = mt_rand(0,100);
$city = $s_name.mt_rand(0,10000000);
$sql .= " ('$s_name', $age, '$city'),";
}
$sql.=" ('test',20,'test');";
$rs = $conn->query($sql);
var_dump($rs."[$s]");
}
$conn->close();
?>
11-16
4312