
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
What happens if a NULL argument is provided in MySQL CONV() function?
MySQL will return NULL as the output if any of the argument of CONV() function is NULL or if the value provided for the base is out of limit(i.e. not between minimum 2 and maximum 36). Following examples would demonstrate it.
Example
mysql> Select CONV(10,NULL,2); +-----------------+ | CONV(10, NULL,2)| +-----------------+ | NULL | +-----------------+ 1 row in set (0.00 sec) mysql> Select CONV(10,10, NULL); +------------------+ | CONV(10,10, NULL)| +------------------+ | NULL | +------------------+ 1 row in set (0.00 sec) mysql> Select CONV(NULL,10,2); +-----------------+ | CONV(null,10,2) | +-----------------+ | NULL | +-----------------+ 1 row in set (0.00 sec)
- Related Articles
- Do we have any lower and upper limit of base in MySQL CONV() function? What happens if out of limit base is provided in CONV() function?
- What happens if we provide NULL as an argument to MySQL CHAR() function?
- What MySQL returns if the list of strings, provided as argument in FIELD() function, are NULL?
- What MySQL returns if the argument of QUOTE() function is NULL?
- What MySQL returns if the search string, provided in FIELD() function, is NULL?
- What MySQL EXPORT_SET() function returns if any of the argument is NULL?
- What MySQL returns if the first argument of INTERVAL() function is NULL?
- What happens if I pass only one argument to the MySQL CONCAT() function?
- What MySQL COALESCE() function returns if all the arguments provided to it are NULL?
- What MySQL ELT() function returns if we the index number, provided as an argument, is less than 1?
- What MySQL returns if the search string is not in the list of strings provided as argument in FIELD() function?
- What MySQL COALESCE() function returns if it has a blank, but not NULL, as the first argument?
- What happens if the value of number ‘N’ in CONV() function is not as per accordance with its base?
- What MySQL ELT() function returns if the index number, provided as an argument, is higher than the number of strings?
- What would be the output of MySQL ELT() function if the index number, provided as an argument, is not an integer?

Advertisements