1 reply

Query for merging LOD but do not override existing areas

Let's say I am playing in a multiplayer world. Suddenly I have a nether portal to a place far away. Now when I get to that far away place, I want LoDs. So I go to a singleplayer world, /tp to that far away place and generate LODs. Now I want to merge the singleplayer LODs but prevent the singleplayer world from overriding already existing LODs on multiplayer database if it already exists at a certain coordinate.
As far as I know something like this will override:

INSERT INTO tablename VALUES (...) ON DUPLICATE KEY UPDATE key_name = key_name;

INSERT INTO tablename VALUES (...) ON DUPLICATE KEY UPDATE key_name = key_name;

But I don't know how to ignore instead of override. i was thinking something like this

ATTACH DATABASE 'path/to/singleplayer.db' AS singleplayer;

INSERT INTO tablename SELECT * FROM singleplayer.tablename ON DUPLICATE KEY 'do not do anything, i dont know how';

ATTACH DATABASE 'path/to/singleplayer.db' AS singleplayer;

INSERT INTO tablename SELECT * FROM singleplayer.tablename ON DUPLICATE KEY 'do not do anything, i dont know how';

Can this be done? What is the syntax for on duplicate key do not insert?

Distant Horizons•2y ago•

1 reply

PixelSamz

Query for merging LOD but do not override existing areas

INSERT INTO tablename VALUES (...) ON DUPLICATE KEY UPDATE key_name = key_name;

INSERT INTO tablename VALUES (...) ON DUPLICATE KEY UPDATE key_name = key_name;

But I don't know how to ignore instead of override. i was thinking something like this

ATTACH DATABASE 'path/to/singleplayer.db' AS singleplayer;

INSERT INTO tablename SELECT * FROM singleplayer.tablename ON DUPLICATE KEY 'do not do anything, i dont know how';

ATTACH DATABASE 'path/to/singleplayer.db' AS singleplayer;

INSERT INTO tablename SELECT * FROM singleplayer.tablename ON DUPLICATE KEY 'do not do anything, i dont know how';

Can this be done? What is the syntax for on duplicate key do not insert?

Query for merging LOD but do not override existing areas

Similar Threads

Query for merging LOD but do not override existing areas

Similar Threads

Similar Threads

Similar Threads