[eyal282]

How to insert for example this query but abort if it already exists within database?

Format(sQuery, sizeof(sQuery), "INSERT INTO LastRequest_players (SteamID, wins, Name) VALUES (\"%s\", '%d', \"%N\")", SteamID, LRWins[client], client);

[shanapu]

INSERT IGNORE INTO

maybe you could also need

INSERT ... ON DUPLICATE KEY UPDATE

https://dev.mysql.com/doc/refman/5.5/en/insert.html

[eyal282]

Originally Posted by shanapu INSERT IGNORE INTO maybe you could also need INSERT ... ON DUPLICATE KEY UPDATE https://dev.mysql.com/doc/refman/5.5/en/insert.html

None of them works ( SQLite by the way )

[shanapu]

Originally Posted by eyal282 SQLite by the way

INSERT OR IGNORE

https://www.sqlite.org/lang_insert.html

[eyal282]

Originally Posted by shanapu INSERT OR IGNORE https://www.sqlite.org/lang_insert.html

And

ON CONFLICT DO UPDATE

Thanks, I'll try the first.

Edit: INSERT OR IGNORE still duplicates and ON CONFLICT DO NOTHING ( instead of update ) gives an error.

[mug1wara]

PHP Code:

replace into 


EDIT:
Aha sorry din't get the question right.

I've sent something in the other thread :p
https://forums.alliedmods.net/showth...=309603&page=3

[eyal282]

Originally Posted by mug1wara PHP Code: replace into

I want to ignore an existing column ( I think it's called column ) because it is safer.

[klippy]

Duplication is based on keys afaik. Show your table structure (its definition) and also what do you consider a "duplicate"? Same SteamID only?

[Neuro Toxin]

Make sure your SteamID column is a unique or primary key.

Then use INSERT INTO .. ON DUPLICATE UPDATE ..

http://www.mysqltutorial.org/mysql-i...te-key-update/

[mug1wara]

Hi Klipp.

@eyal, you want to ignore an existing row or column.

Row:
results.RowCount

Column:
results.FetchInt