PhantomBurn
04-27-2008, 12:16 PM
Hey,
Right now I have 2 databases. One is called maplestory and one is called odinms. I'm trying to copy the data from the character table in maplestory to the character table in odinms. The 2 don't have the same column names though, but I thought that wouldn't really matter with the query I was using:
INSERT INTO odinms.characters (id, name, accountid, level, job, str, dex, int, luk, hp, maxhp, mp, maxmp, ap, sp, exp, fame, map, gender, skincolor, face, hair, meso)
SELECT ID, name, usersid, level, job, str, dex, intt, luk, chp, mhp, cmp, mmp, ap, sp, exp, fame, map, gender, skin, eyes, hair, mesos
FROM maplestory.characters
From what I understand, that will select the info from maplestory characters and put it into odinms characters. So, column ID will go into id, name into name, userid into accountid, etc....
When I run it though it says I have a syntax error on line one.
Anyone know whats wrong?
Right now I have 2 databases. One is called maplestory and one is called odinms. I'm trying to copy the data from the character table in maplestory to the character table in odinms. The 2 don't have the same column names though, but I thought that wouldn't really matter with the query I was using:
INSERT INTO odinms.characters (id, name, accountid, level, job, str, dex, int, luk, hp, maxhp, mp, maxmp, ap, sp, exp, fame, map, gender, skincolor, face, hair, meso)
SELECT ID, name, usersid, level, job, str, dex, intt, luk, chp, mhp, cmp, mmp, ap, sp, exp, fame, map, gender, skin, eyes, hair, mesos
FROM maplestory.characters
From what I understand, that will select the info from maplestory characters and put it into odinms characters. So, column ID will go into id, name into name, userid into accountid, etc....
When I run it though it says I have a syntax error on line one.
Anyone know whats wrong?