MySQL insert into one more record SQL statement

For example, you can do this:

The code is as follows	Copy Code
Mysql> INSERT into Tbl_name (col1,col2) VALUES (15,col1*2);

When you insert multiple database records, we often write this:

The code is as follows	Copy Code
$name = ' Soulcy '; for ($i = 0; $i <= 5; $i + +) { $sql = "INSERT into users (UID, name) VALUES (". $i. ",". $name. ")"; mysql_query ($sql); }

This writing is inefficient and requires multiple execution of SQL statements. If you've used phpMyAdmin to import data, you'll actually find that the above statement can actually be written

The code is as follows	Copy Code
INSERT into ' users ' (' uid ', ' name ') VALUES (0, ' Soulcy '), (1, ' soulcy ');

Ideally, therefore, a single SQL insert more than one piece of data.

code is as follows	copy code
$name = ' Soulcy '; for ($i = 0; $i <= 5; $i + +) {      if ($i = 0)      { &NBSP;&N bsp;        $sql = "INSERT into users (UID, name) VALUES (". $i. ", '". $name. ")";     }      Else      {            $sql = ", (". $i. ", '". $name. ")";     } } mysql_query ($sql);