Function MySQL

  1. Home
  2. MySQL
  3. Function
  4. IF( ) and IFNULL( ) are useful for catching divide-by-zero operations
mysql>
mysql>
mysql> SET @hits = 0, @atbats = 0;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT @hits, @atbats, @hits/@atbats AS 'batting average';
+-------+---------+-----------------+
| @hits | @atbats | batting average |
+-------+---------+-----------------+
|     0 |       0 |            NULL |
+-------+---------+-----------------+
1 row in set (0.00 sec)
mysql>