LOAD DATA [LOCAL] INFILE 这条命令是从文档里向表中导入数据的,这个文档应该在WINDOWS的哪个路径下啊?INTO OUTFILE 命令向文本中导出数据的是是在\DATA\库名\里的,但是好象不能从这里读入文档数据.
Taburiss
2005-02-18 20:57
mysql自带的说明文件里面就有咯~~~13.1.5章~~
代码
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES [STARTING BY ''] [TERMINATED BY '\n'] ] [IGNORE number LINES] [(col_name,...)]
