How to load data into Mysql from txt file? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

How to load data into Mysql from txt file?

How to load data into Mysql from txt file?# Database - 数据库

j*k2002-10-09 07:10

1 楼

I tried to load a text file into an empty table,with "load data local infile
"file.txt" into table tablename", got error 1148:
the used command is not allowed with is MySQL version
My version is 3.23.52 and the manual dose suggests using load data.
Anybody can help?

o*z2002-10-09 07:10

2 楼

it's disabled by default for security reason
you need to invoke the client with --local-infile=1
mysql --help for more information

【在 j*****k 的大作中提到】

: I tried to load a text file into an empty table,with "load data local infile
: "file.txt" into table tablename", got error 1148:
: the used command is not allowed with is MySQL version
: My version is 3.23.52 and the manual dose suggests using load data.
: Anybody can help?