|
Ответ: Добавить запись если не существует.
http://dev.mysql.com/doc/refman/5.0/...duplicate.html
Например:
INSERT INTO users
SET
`id` = 1,
`name` = "ololosha",
`pass` ="somepass"
ON DUPLICATE KEY UPDATE
`name` = "ololosha",
`pass` = "somepass"
id - PRIMARY KEY (или UNIQUE)
__________________
Retry, Abort, Ignore? █
Intel Core i7-9700 4.70 Ghz; 64Gb; Nvidia RTX 3070
AMD Ryzen 7 3800X 4.3Ghz; 64Gb; Nvidia 1070Ti
AMD Ryzen 7 1700X 3.4Ghz; 8Gb; AMD RX 570
AMD Athlon II 2.6Ghz; 8Gb; Nvidia GTX 750 Ti
|