Arithmetic Operators Example:- Here I am putting a few examples, which will explain how Arithmetic operators are working in mysql:- SELECT 5 + 7; Result :- 12 SELECT 8 – 6; Result :- 2 SELECT
Continue ReadingCategory: Science And Technology
MySQL Operators
MySQL Operators:- Operators are basically used to modify information of the group of data, So They apply conditions with the “WHERE” clause. In MySQL, we can use different types of operators. Hence, We can say
Continue ReadingMySQL BINARY and VARBINARY Data Type
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 ReadingMYSQLSET 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 Reading