Get the type of variable in MySQL?

Unable to get the type of variable in MySQL. Use the CAST operator to convert a variable's type to another type. The syntax is as follows -

SET @yourVariableName:=’anyValue’

Convert to another type using the CAST operator. The syntax is as follows -

SELECT CAST( @yourVariableName AS SIGNED);

To understand the above syntax, let us convert to another type.

Case 1: String converted to unsigned -

mysql> set @StringToInt:='12345';
Query OK, 0 rows affected (0.00 sec)

Another type of query is as follows-

mysql> select CAST(@StringToInt as UNSIGNED);

The following is the output-

+--------------------------------+
| CAST(@StringToInt as UNSIGNED) |
+--------------------------------+
| 12345                          |
+--------------------------------+
1 row in set (0.00 sec)

Case 2: Int to char

The query is as follows-

mysql> set @IntTochar:=CAST(65 as CHAR);
Query OK, 0 rows affected (0.00 sec)

The query is as follows-

mysql> select @IntTochar;

The following is the output-

+------------+
| @IntTochar |
+------------+
| 65         |
+------------+
1 row in set (0.00 sec)

The above is the detailed content of Get the type of variable in MySQL?. For more information, please follow other related articles on the PHP Chinese website!