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 […]
Author Archives: user
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 – Character Set Table of content The MySQL Character Set The MySQL Character set is used to determine the set of permissible characters within a string. It allows for the storage of data in various character encodings. By default, MySQL uses the “utf8mb4” character set. These character sets provides several functionalities − Storage Variety […]