![]() This statement changes the error that MySQL throws when you use a normal INSERT statement into a warning so that the execution of your query isn’t interrupted. The MySQL INSERT IGNORE statement is used to insert a new row and ignore execution errors causes by the statement. Without putting a constraint on the column that you want to be distinct, then MySQL will insert duplicate values just fine, and the following tutorials won’t work as intended. ![]() Keep in mind that before you create an insert row if not exists query, the MySQL table in use must already have one or more column(s) with PRIMARY KEY or UNIQUE constraint.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |