CSDN 6428632条数据mysql 32.25s安插完毕

CSDN 6428632条数据mysql 32.25s插入完毕

mysql> create table csdn(id int not null auto_increment primary key,username varchar(50) not null,password varchar(50) not null,email varchar(50) not null);Query OK, 0 rows affected (0.21 sec)

mysql> load data local infile '/media/Happy/F/Database/password/www.csdn.net.sql' replace into table csdn fields terminated by ' # ' lines terminated by 'n' (username,password,email);
Query OK, 6428632 rows affected, 295 warnings (32.25 sec)
Records: 6428632  Deleted: 0  Skipped: 0  Warnings: 295

mysql> select count(*) from csdn;
+----------+
| count(*) |
+----------+
|  6428632 |
+----------+
1 row in set (0.09 sec)

耗时：32.25 sec

相关文章：

你感兴趣的文章：

标签云：