In this case if record exists, the query will overwrite the entry with values but if it does not exist with userid, it will enter a new entry. Method 2 ' INSERT IGNORE' :- INSERT IGNORE INTO `users` ...
I hadn't caught this in testing, since I've switched to MariaDB when Linux distros started shipping it as the default over MySQL, many years ago. But it seems that MySQL still doesn't support CREATE ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback