MySQL – Useful Functions Built-in MySQL Functions Here is the list of all important MySQL functions. Each function has been explained along with suitable examples. − Complete list of MySQL Date and Time related functions. − Complete list of MySQL functions required to manipulate numbers in MySQL. − Complete list of MySQL functions required to […]

MySQL – COALESCE() Function Table of content Sometimes a record in a table might have missing data that the user cannot fill with zeroes. In such cases, MySQL allows the user to fill that record with a NULL value. A NULL value is nothing but a placeholder in database tables to represent missing values or […]

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