ERROR 1148 (42000): The used command is not allowed with this MySQL version
来源:互联网 发布:怎样装饰淘宝店铺2016 编辑:程序博客网 时间:2024/05/01 16:42
今天在使用mysql的LOAD DATA LOCAL INFILE 语法插入文件的时候,提示:ERROR 1148 (42000): The used command is not allowed with this MySQL version
原因是;如果编译安装mysql时没有指定–enable-local-infile,那么在使用上述命令时会报以上的错误:
解决方法:
解决方式有两种,一是重新编译安装加上上面的参数:
./configure --prefix=/usr/local/mysql --enable-local-infilemakemake install
二是直接用命令行执行,例如:
mysql -uroot -proot mydb_name --local-infile=1 -e 'load data local infile "/home/xyw/tmp/AS.txt" into table AS_China fields terminated by "\t" lines terminated by "\n";'mysql -uroot -proot mydb_name --local-infile=1 -e 'load data local infile "/home/xyw/tmp/AS.txt" into table AS_China(Name);'
本文为Eliot原创,转载请注明出处:http://blog.csdn.net/xyw_blog/article/details/17922147
1 0
- ERROR 1148 (42000): The used command is not allowed with this MySQL version
- ERROR 1148 (42000): The used command is not allowed with this MySQL versio
- Mysql load 出现 The used command is not allowed with this MySQL version
- Mysql load 出现 The used command is not allowed with this MySQL version
- Mysql load 出现 The used command is not allowed with this MySQL version
- MYSQL-执行“load data local infile”报错“The used command is not allowed with this MySQL version”
- mysql load data infile 文件没有找到(can't get file stat) ERROR 1148: The used command is not allowed with
- Error running example: This version of Android Studio is incompatible with the Gradle Plugin used.解决
- Error running app: This version of Android Studio is incompatible with the Gradle Plugin used. Try
- Error running app: This version of Android Studio is incompatible with the Gradle Plugin used.
- Error running app: This version of Android Studio is incompatible with the Gradle Plugin used.
- Error running app: This version of Android Studio is incompatible with the Gradle Plugin used. Try
- Error running app: This version of Android Studio is incompatible with the GradleTry d Plugin used.
- Error running demo: This version of Android Studio is incompatible with the Gradle Plugin used.
- Error running app.main: This version of Android Studio is incompatible with the Gradle Plugin used.
- Error running app: This version of Android Studio is incompatible with the Gradle Plugin used.
- Error running app: This version of Android Studio is incompatible with the Gradle Plugin used. Try d
- Error running app: This version of Android Studio is incompatible with the Gradle Plugin used. Try d
- android系统sensor代码路径
- Config语言与Config.in文件
- QT QButton to QMenu自定义菜单
- serialVersionUID的作用
- 如何跨越现实和梦想之间的鸿沟
- ERROR 1148 (42000): The used command is not allowed with this MySQL version
- jrebel 热部署工具
- 当服务器空间不足的时候,删除属于自己的版本。
- 如何将BMP文件转换为JPG文件
- 学习Ajax技术
- myibatis的写法
- struts2采用convention-plugin实现零配置
- 谷歌调试工具祝你一臂之力买火车票,简单安全方便
- epoll_create, epoll_ctl和epoll_wait 讲解