Category Archives: mysql

MySQL – Distinct Clause Table of content MySQL DISTINCT clause The DISTINCT clause in MySQL is used with a SELECT statement to return the distinct values (unique values) from a single or multiple of columns in a table. It ignores all the duplicates values present in the particular column(s) and returns only the distinct values. […]

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 Into Select Table of content The MySQL Insert Into Select Statement In MySQL, the INSERT INTO… SELECT statement is used to add/insert one or more rows from an existing table to target table. This statement is a combination of two different statements: INSERT INTO and SELECT. The MySQL INSERT INTO statement is […]