你可以在客户端运行这条指令LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]LOAD DATA INFILE语句从一个文本文件中以很高的速度读入一个表中。如果指定LOCAL关键词,从客户主机读文件。如果LOCAL没指定,文件必须位于服务器上。(LOCAL在MySQL3.22.6或以后版本中可用。)
你也可以以INSERT的SQL语句保存为文本文件用以备份,
恢复时再从文本文件中读出INSERT的SQL语句,
一句句运行
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]LOAD DATA INFILE语句从一个文本文件中以很高的速度读入一个表中。如果指定LOCAL关键词,从客户主机读文件。如果LOCAL没指定,文件必须位于服务器上。(LOCAL在MySQL3.22.6或以后版本中可用。)
你也可以以INSERT的SQL语句保存为文本文件用以备份,
恢复时再从文本文件中读出INSERT的SQL语句,
一句句运行
$sql="LOAD DATA LOCAL INFILE \"c:/$name\"
INTO TABLE $tmp FIELDS TERMINATED BY ','
(pk_com,pk_typ,pk_doc,pk_seq,pk_code,pk_pfit,pk_dept,pk_drcr,pk_date,pk_qty,pk_amt,pk_usd,pk_rate,pk_desc)";
LOAD DATA LOCAL INFILE 'c:/upload/Gls0209.txt' INTO TABLE tmp_table FIELDS TERMINATED BY ',' (pk_com,pk_typ,pk_doc,pk_seq,pk_code,pk_pfit,pk_dept,pk_drcr,pk_date,pk_qty,pk_amt,pk_usd,pk_rate,pk_desc)但是就是找不到这个文件。