Syntax error when trying to import table [duplicate]

Question

I'm trying to import a table from a database to another but keep getting this error

the command:

INSERT IGNORE INTO epdbraid.spawnpoints ( 
    id, spawn_id, lat, lon, despawn_time, updated 
) 
SELECT 
    0, 
    CAST(CONV(id,16,10) AS INTEGER), 
    latitude, longitude, latest_seen, last_scanned 
FROM rocketmapdb.spawnpoint;

The error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTEGER), latitude, longitude, latest_seen, last_scanned FROM rocketmapdb.spawnp' at line 1

sql version: mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper

Any idea what I'm doing wrong?

halfer · Accepted Answer · 2019-07-07 22:36:32Z

1

INSERT IGNORE INTO epdbraid.spawnpoints ( 
    id, spawn_id, lat, lon, despawn_time, updated 
) 
SELECT 
    0, 
    CAST(CONV(id,16,10) AS  UNSIGNED ), 
    latitude, longitude, latest_seen, last_scanned 
FROM rocketmapdb.spawnpoint;

You can try above code.

edited Jul 7, 2019 at 22:36

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Jul 7, 2017 at 10:35

Sagar Gangwal

8,1303 gold badges28 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ernestina franco Over a year ago

this worked thank you very much!

Collectives™ on Stack Overflow

Syntax error when trying to import table [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related