CHAR and VARCHAR Data Type:- The CHAR and VARCHAR Data types are similar, but differ in the way they are stored and retrieved. CHAR and VARCHAR are declared with a fixed length, which declares how
Month: February 2022
BOOLEAN, FLOAT, DOUBLE, DECIMAL MYSQL Data Type
Here I am discussing BOOLEAN, FLOAT, DOUBLE, and DECIMAL MYSQL Data Type. BOOLEAN Data Type:- MySQL does not have a BOOLEAN data type. MySQL converts a BOOLEAN value into integer data type TINYINT. So, MySQL
TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT
The TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT MySQL Data Types are used for MySQL integer data value. They differ only from storage value and range value. Storage point of view TINYINT stores 1 byte, SMALLINT
BIT MySQL Data Type
The BIT MySQL data type is used for bit value. The bit value range will be 1 to 64 bytes. It stores values in binary form (0 and 1). The syntax for the BIT data
MySQL Data Type
Data type mainly defines which type of data an object can hold. The data type property is very important for optimizing the database. That means, As per our requirement, only those types and sizes of
MySQL AUTO INCREMENT
MySQL AUTO INCREMENT constraint is used for sequentially automatically generating numeric values every time a record is inserted into a table. AUTOINCREMENT allows unique value. Often, we use AUTOINCREMENT with PRIMARY KEY constraints. MySQL uses
MySQL INDEX Constraint
In MySQL INDEX is used to find rows of specific column values fastly. Without indexing MySQL starts reading from the first rows and then goes through the entire table to find a relevant row. So
MySQL DEFAULT Constraint
MySQL DEFAULT Constraint is used to set default values for a data column. When we add a new record and we are not inserting any value of a particular DEFAULT Constraint column, then the default
MySQL NOT NULL Constraint
NOT NULL Constraint enforces the column not to accept a NULL value. It is a way to add another layer of validation of data. A NULL value means no value on the data row. By
