mysql 批量导入html_[转]mysql批量导入已经格式好的文本数据

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'

[REPLACE | IGNORE]

INTO TABLE tbl_name

[CHARACTER SET charset_name]

[FIELDS

[TERMINATED BY 'string']

[[OPTIONALLY] ENCLOSED BY 'char']

[ESCAPED BY 'char']

]

[LINES

[STARTING BY 'string']

[TERMINATED BY 'string']

]

[IGNORE number LINES]

[(col_name_or_user_var,...)]

[SET col_name = expr,...]

使用如下命令：

LOAD DATA LOCAL INFILE 'C:\\stu.txt' INTO TABLE stu;

因为这是一条SQL语句，你同样可以在你的JAVA程序序中用：

st.execute(“LOAD DATA LOCAL INFILE 'C:\\stu.txt' INTO TABLE stu”);

(st表示Statement的一个实例变量，假设数据库连接，st的初使化已经完成)

创建stu表：

create table stu_other(id int auto_increment primary key,stu_name varchar(50),age int);