j*****k
发帖数: 1 | 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***z
发帖数: 133 | 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?
| s**********i
发帖数: 711 | 3
yes, loading local file is not enabled by default.
can upload to server first then use
load data infile
【在 o***z 的大作中提到】
: it's disabled by default for security reason
: you need to invoke the client with --local-infile=1
: mysql --help for more information
|
|
