插入数据时候,引用了数据库名,数据库名中有横线,会提示错误:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right sy ntax to use near '-all.db1(operationuser,operationtime,notes,ebay_id,types)
解决办法:
把数据库名、表名都用反引号引起来就可以了。
比如:
insert into `db1`.`tbl1`(operationuser,operationtime,notes,ebay_id,types)(select operationuser,operationtime,notes,ebay_id,types from `db2`.`tbl2` where `operationtime` >1367337600 order by id asc);
黑洞@heidsoft
Github:https://github.com/heidsoft
微博:http://weibo.com/liuganbin
热衷云计算和大数据
关注CloudStack,OpenStack,Linux c/c++/python/java
关注研究新技术