Category Archives: mysql

MySQL – Limit Table of content MySQL Limit Clause The LIMIT clause in MySQL can be used to specify the number of records to return. This clause is mostly used when dealing with tables that have thousands of records. It accepts one or two arguments (offset or count). The values of both arguments should be […]

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 […]