Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php向mysql插入1000条数据，如何写?

php向mysql插入1000条数据，如何写?

WBOY
Release： 2016-06-13 13:18:06
Original
903 people have browsed it

php向mysql插入1000条数据，怎么写???
for($i=1;$i{
  $id="100";
  $username="xm";

  $sql="insert into tb_user(id,username) values('$id','$username')";
  mysql_query($sql);
}


我没有设置id和username成主键喔，

可只是插入一条数据，问题出现那里啊？请教高手，谢谢

------解决方案--------------------
不要频繁操作数据库。建议

PHP code

 for ($i=1; $i
Copy after login
Related labels：
mysql nbsp quot sql
source：php.cn
Previous article： 请问个smarty模版技术的有关问题 Next article： PHP中系统登录的取值有关问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
Compare CSV rows in php I have the following code that allows me to generate a csv file from a database. <?phpr...
From 2024-04-04 13:57:04
0
1
355
How to write MySql insert trigger based on inserted data value? I want to write a trigger for table users. When a new user is added, if his title is relat...
From 2024-04-03 16:42:38
0
1
278
add jpg image from mysql to html As a preface, I'm very new to this so this might be a stupid question, but... I'm trying t...
From 2024-04-02 13:27:34
0
1
344
Function to run before useEffect completes I have this code: constChatsPage=()=>{letusername=""letssecret=""us...
From 2024-04-01 23:34:29
0
1
345
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template