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 […]
Category Archives: mysql
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 – Statements Reference Table of content Here is the list of all important MySQL statements. Each statement has been explained along with suitable example. Data Definition Statements − This statement is used to change the characteristics of an existing database. − This statement is used to change the characteristics of an existing event. − […]