Category Archives: mysql

MySQL – Storage Engines Table of content The MySQL Storage Engines As we already know, a MySQL database is used to store data in the form of rows and columns. The MySQL storage engine is a component that is used to handle the SQL operations performed to manage this data. They work with simple tasks […]

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