Category Archives: mysql

MySQL – Aliases Table of content The MySQL Alias The MySQL Alias is used to assign a temporary name, called an Alias to a table or a column in SQL. Aliases are created using the AS keyword and are used to refer to a specific table or a column without changing its original name. They […]

MySQL – Check Constraint Table of content The MySQL Check Constraint The MySQL Check Constraint is a condition that can be applied to a column to ensure that the inserted or updated data in that column meets the specified condition. The database rejects the operation if the condition is not met to maintain data integrity. […]

MySQL – Import CSV into database Table of content Import MySQL CSV into Database To import the MySQL data from a CSV file into a database table, we can use the MySQL LOAD DATA INFILE statement. Before importing the CSV file into the database server, we must ensure the following things − Database Table − […]