BINARY and VARBINARY Data Type:- BINARY and VARBINARY data types contain a binary string. It is similar to CHAR and VARCHAR data types. The only difference is BINARY and VARBINARY data types store byte strings
Continue ReadingCategory: Science And Technology
MYSQLSET Data Type
SET Data Type:- MYSQL SET is a data type string object which can hold zero or more value. It must be chosen from the predefine specified value. A SET column can have a maximum of
Continue ReadingENUM MySQL Data Type
ENUM is a sort of enumeration. which means each column of the table has one of the possible values. It is a String Object. It uses a numeric index to represent string values. Following are
Continue ReadingCHAR and VARCHAR MySQL Data Type
CHAR and VARCHAR Data Type:- The CHAR and VARCHAR 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 many
Continue ReadingBOOLEAN,FLOAT, DOUBLE, 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 considers 0 for false and 1 for true. Even MySQL uses the
Continue ReadingTINYINT, SMALLINT, MEDIUMINT, INT, BIGINT MySQL Data Type
TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT Data Type 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 stores 2 bytes,
Continue ReadingMySQL Data Type
Data type mainly defines which type of data 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 fields
Continue ReadingMySQL 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
Continue ReadingMySQL INDEX Constraint
In MySQL INDEX is used to find rows of specific column values fastly. Without indexing MySQL start reading from the first rows and then go through the entire table to find a relevant row. So
Continue ReadingMySQL 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
Continue Reading