- 论坛徽章:
- 0
|
我有两个数据库EATHENA和KJATHENA 两个数据库的字段有些不同
我想把EA的数据导入到KJA上。 我这么写的:
insert into `kjathena`.`cart_inventory` select `id`,`char_id`,`nameid`,`amount`,`equip`,`identify`,`refine`,`attribute`,`card0`,`card1`,`card2`,`card3`,0 fXm `eathena`.`cart_inventory`;
cart_inventory表
但是MYSQL4.1报错
正确的写法是什么?请教。
SQL 查询:
INSERT INTO `xathena`.`cart_inventory`
SELECT `id` , `char_id` , `nameid` , `amount` , `equip` , `identify` , `refine` , `attribute` , `card0` , `card1` , `card2` , `card3` , 0fXm `eathena`.`cart_inventory` ;
MySQL 返回:
#1064 - You have an erXr in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'eathena`.`cart_inventory`' at line 1 |
|