Distant Horizons•6mo ago

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?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Query for merging LOD but do not override existing areas