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.01 sec)
use csdn;
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);