Category Archives: mysql

MySQL – REPLACE Query Table of content MySQL REPLACE Statement In general, if we want to add records into an existing table, we use the MySQL INSERT statement. Likewise, we can also add new records or replace an existing records using the MySQL REPLACE statement. The replace statement is similar to the insert statement. The […]

MySQL – Insert Ignore Table of content In MySQL, the INSERT INTO statement can be used to insert one or more records into a table. In some scenarios, if a particular column has a UNIQUE constraint and if we are trying to add duplicates records into that particular column using the INSERT INTO statement, MySQL […]

MySQL − Insert on Duplicate Key Update Table of content The INSERT INTO statement in MySQL is used to insert new records into a specific table. MySQL Insert on Duplicate Key Update Statement When we are trying to insert a new row into a MySQL table column with a UNIQUE INDEX or PRIMARY KEY, MySQL […]