Category Archives: mysql

MySQL – VARCHAR Table of content The MySQL Varchar Data Type The MySQL VARCHAR data type is used to store variable-length character strings, having a length up to 65,535 bytes. In MySQL, when you store text in a VARCHAR column, it needs a little extra space to keep track of how long the text is. […]

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

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