我是首先创建了一个emustu的数据库,接着创建一张emu_student表,代码如下:
create table emu_student (
sid bigint not null primary key,
firstname char(50) not null,
lastname char(50) not null,
username char(50) not null,
password char(50) not null,
secret char(50) not null
);
现有一emu_student.dat的数据文件,里面的数据为:
1:guest:lnu:guest:5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8:secret
2:admin:lnu:admin:d033e22ae348aeb5660fc2140aec35850c4da997:secret
试问该怎么将我所需要的数据导入到数据库中???
create table emu_student (
sid bigint not null primary key,
firstname char(50) not null,
lastname char(50) not null,
username char(50) not null,
password char(50) not null,
secret char(50) not null
);
现有一emu_student.dat的数据文件,里面的数据为:
1:guest:lnu:guest:5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8:secret
2:admin:lnu:admin:d033e22ae348aeb5660fc2140aec35850c4da997:secret
试问该怎么将我所需要的数据导入到数据库中???
<?php
mysql_connect('localhost', 'root', '');
mysql_query('use test');
mysql_query("SET NAMES 'utf8'");$sql = "
LOAD DATA LOCAL INFILE 'D:\\www\\project\\test\\emu_student.dat'
INTO TABLE emu_student
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\n'
(sid, firstname, lastname, username, password, secret);
";mysql_query($sql);
LOAD DATA LOCAL INFILE 'D:\\www\\project\\test\\emu_student.dat'
INTO TABLE emu_student
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\n'
(sid, firstname, lastname, username, password, secret);