Author Archives: user

MySQL – CREATE VIEW Table of content MySQL views are a type of virtual tables. They are stored in the database with an associated name. They allow users to do the following − Structure data in a way that users or classes of users find natural or intuitive. Restrict access to the data in such […]

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

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