运行Load data local infile命令时:
mysql> LOAD DATA LOCAL INFILE '/path/file' INTO TABLE tablename;
出现:
ERROR 1148 (42000): The used command is not allowed with this MySQL version
这是因为:
服务器端,local_infile默认开启;客户端,local_infile默认关闭,因此用的时候需要打开。
On the server side:
The local_infile system variable controls server-side LOCAL capability. Depending on the local_infile setting, the server refuses or

最低0.47元/天 解锁文章
2807

被折叠的 条评论
为什么被折叠?



