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 – Alternate Key Table of content An Alternate Key in a table is nothing but an alternative to the primary key in that table. In other words, they are candidate keys that are not currently selected as the primary key of a table (but has a potential to be one). Hence, they can also […]