Category Archives: mysql

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

MySQL – BLOB Table of content Many user applications require the storage of different types of data, including text, images, files, and more. Using BLOBs in a MySQL database allows you to store all these types of data within the same database, eliminating the need for a separate file system. The MySQL BLOB Data Type […]