Category Archives: mysql

MySQL – Change Column Type Table of content In MySQL, users have the flexibility to modify the data type of a field. This is useful when you initially set the wrong data type for a column in a new database table, or when you need to adjust the storage size for the values in a […]

MySQL – Collation Table of content MySQL Collation is a set of rules used to decide how to compare and sort various characters of a character set. MySQL supports multiple character sets including ASCII, Unicode System, Binary, etc. Every character of these character sets is subjected to a weight. A MySQL collation orders the characters […]

MySQL – Aliases Table of content The MySQL Alias The MySQL Alias is used to assign a temporary name, called an Alias to a table or a column in SQL. Aliases are created using the AS keyword and are used to refer to a specific table or a column without changing its original name. They […]