Sample Header Ad - 728x90

How to find data type of output in MySQL?

3 votes
3 answers
4922 views
I was reading about the CONCAT() function, and I noticed this:
mysql> SELECT CONCAT(14.3);
        -> '14.3'
While running this command in MySQL 8.0 Command Line Client, the output didn't have quotes. So I wanted to verify the data type of the output (I assume it is a string data type). Please help me find the data type of the output.
Asked by Random Person (157 rep)
Mar 20, 2022, 10:18 AM
Last activity: Apr 28, 2023, 01:13 AM