Mysql CAST(amount as float)

Cast float mysql

SELECT
    integer_column + 0.0 AS float_column

Source: stackoverflow.com

Parsing float to int in mysql

SELECT CONVERT(150, CHAR);

Mysql CAST(amount as float)

mysql> SELECT CAST(4 AS DECIMAL(4,3));
+-------------------------+
| CAST(4 AS DECIMAL(4,3)) |
+-------------------------+
|                   4.000 |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT CAST('4.5s' AS DECIMAL(4,3));
+------------------------------+
| CAST('4.5s' AS DECIMAL(4,3)) |
+------------------------------+
|                        4.500 |
+------------------------------+
1 row in set (0.00 sec)

mysql> SELECT CAST('a4.5s' AS DECIMAL(4,3));
+-------------------------------+
| CAST('a4.5s' AS DECIMAL(4,3)) |
+-------------------------------+
|                         0.000 |
+-------------------------------+
1 row in set, 1 warning (0.00 sec)

Source: stackoverflow.com

Similar codes

0 vote144 views1 answer
Delete data from database sqlite android
SQL
0 vote148 views1 answer
Select all columns except one sql
SQL
0 vote192 views1 answer
Doctors appointment
SQL
0 vote194 views1 answer
Selecting from a view SQL
SQL
10 votes149 views2 answers
Mysql remove only_full_group_by permanently
SQL
1 vote159 views1 answer
Mysql show long running queries
SQL
-1 vote150 views2 answers
Full join sql
SQL
0 vote179 views1 answer
Mysql loop through databases and execute query
SQL
0 vote147 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote155 views1 answer
Find the names of sailors who have reserved at least one boat
SQL