Problem with WHERE NOT EXISTS #18

New Issue

Padsou · 2022-04-28T06:13:25Z

Padsou commented

2022-04-28 06:13:25 +00:00

Hi

I'm in spigot 1.18.1 and the last version of skript-db

I want that when a player connects to the server it adds him to the database if he doesn't already exist.

I tried the following command but it doesn't work, it tells me that I have an error on my WHERE NOT EXISTS

The INSERT INTO part works perfectly

execute "INSERT INTO player (name,uuid,grade) VALUES (%name of player%,%uuid of player%,%{grade.info.%player%}%) WHERE NOT EXISTS ( SELECT uuid,name FROM player WHERE name=%name of player% AND uuid=%uuid of player% )" in {sql}

Does anyone have an idea how to solve the problem?

Hi I'm in spigot 1.18.1 and the last version of skript-db I want that when a player connects to the server it adds him to the database if he doesn't already exist. I tried the following command but it doesn't work, it tells me that I have an error on my WHERE NOT EXISTS The INSERT INTO part works perfectly ![2022-04-28_08.10.51](/attachments/124bbc3e-73ca-44b4-9164-b09be63c0520) ```SQL execute "INSERT INTO player (name,uuid,grade) VALUES (%name of player%,%uuid of player%,%{grade.info.%player%}%) WHERE NOT EXISTS ( SELECT uuid,name FROM player WHERE name=%name of player% AND uuid=%uuid of player% )" in {sql} ``` Does anyone have an idea how to solve the problem?

2022-04-28_08.10.51.png

29 KiB

Govindas commented

2022-04-28 11:54:16 +00:00

you don't need where not exist in insert, just create unique key on uuid, then insert will fail if it already exists