菜鸟学sql语句第二课
第一步:D盘里的txt文件如下: 路径为:d:/data/mysql.txt
[img]
[img]http://dl.iteye.com/upload/attachment/0080/9641/5584b150-7d3c-3ccf-9674-b6a1cbdf6344.png[/img]
[/img]
第二步:创建表:
[img]
[img]http://dl.iteye.com/upload/attachment/0080/9643/4d743902-3356-3d92-a631-0ec24c1631ce.png[/img]
[/img]
第三步:把数据导入数据库
[img]
[img]http://dl.iteye.com/upload/attachment/0080/9645/f0f91589-1e7e-3a7b-a93d-083cf3f3c03d.png[/img]
[/img]
[color=red]注意:mysql.txt文件的格式,每一列的数据中间需点击下Tab键隔开。[/color]
第一步:D盘里的txt文件如下: 路径为:d:/data/mysql.txt
[img]
[img]http://dl.iteye.com/upload/attachment/0080/9641/5584b150-7d3c-3ccf-9674-b6a1cbdf6344.png[/img]
[/img]
第二步:创建表:
create table msg(
id int,
name varchar(20),
sex varchar(10),
age1 int,
age2 int
)
[img]
[img]http://dl.iteye.com/upload/attachment/0080/9643/4d743902-3356-3d92-a631-0ec24c1631ce.png[/img]
[/img]
第三步:把数据导入数据库
load data local infile "d:/data/mysql.txt" into table msg;
[img]
[img]http://dl.iteye.com/upload/attachment/0080/9645/f0f91589-1e7e-3a7b-a93d-083cf3f3c03d.png[/img]
[/img]
[color=red]注意:mysql.txt文件的格式,每一列的数据中间需点击下Tab键隔开。[/color]