Author Archives: user

MySQL – Boolean Datatype Table of content A Boolean data type is used to represent truth values of logic and Boolean algebra. It has two possible values: either true or false. For example, if a customer wants to see all the bikes that are black in colour, we can filter them using BOOLEAN operator, as […]

MySQL – DECIMAL Table of content The MySQL Decimal Data Type The MySQL DECIMAL data type is used to store numeric values with decimal points. It allows for precise calculations and can be configured to store a specified number of digits before and after the decimal point. We often use this datatype for the columns […]

MySQL – ENUM Table of content ENUM (Enumerator) is a user defined datatype which stores a list of values as strings. These values are specified when you define the ENUM column. The user can choose values from this predefined list while inserting values into this column. Each string value defined in an ENUM column is […]