WE can convert any number from one mathematical base number system to another base number system by using conv() function in MySQL. Here is the syntax

conv(n,base_from, base_to);

Here n is any number and base_from is base of n ( the number ) at present. base_to is the base of the number we want to covert. Minimum base value is 2 and maximum base value is 36. Let us try one example

Select conv('b',16,2);

Here number is b of base 16 , after conversion it will have base of 2 . The output is here

1011

Now let us try one octal number

Octal number to decimal ( base 10 )

conv(11,8,10)

In above code number 11 is of base 8 and after conversion it became decimal number of base 10. Here is our output