How can I make an insert with a where condition?
I have the following query:
INSERT INTO `registro`(`id`, `username`) values ('','USER_1'), ('','USER_2'), ('','USER_3')
It will add a new user in the record table. Only I need him to check if this user already exists in the DB, if he already exists he should not insert. This check should only be done for the
I read in some places that INSERT does not accept WHERE, in that case how should it be done?
In SQL you can do like this
INSERT INTO pessoa (id, nome, sexo, datanascimento, cpf) SELECT 227,'FULANDO DE TAL','F','1999-09-09', '999.999.999-9' WHERE NOT EXISTS (SELECT 1 FROM pessoa WHERE id = 227);