Big Data quick way to insert MySQL via PHP

If your MySQL is installed through brew, then please

Vi/usr/local/cellar/mysql/5.6.23/my.cnf

Will

Max_allowed_packet = 64M

Write save and restart MySQL, then go to MySQL CLI to run

Show variables like ' Max_allowed_packet ';

You can see if the change was successful, and then write the PHP file:

$sql = "INSERT INTO Biao (column_name) values"; for ($i = 0; $i < 5000000; $i + +) {    $sql. = "(' value′),";}; $sql = substr ($sql, 0, strlen ($sql)-1); $connect _mysql->query ($sql);

Execute it and you'll see the results in the database.

Big Data quick way to insert MySQL via PHP