mysql> select (select 1 union select 2);
ERROR 1242 (21000): Subquery returns more than 1 row
mysql> select 313130e302*30000000e300;
ERROR 1690 (22003): DOUBLE value is out of range in '(313130e302 * 30000000e300)'
mysql> select exp(740);
ERROR 1690 (22003): DOUBLE value is out of range in 'exp(740)'
mysql> select 99999999999999999999999999*99999999999999999999999999999999999999999999999999999999;
ERROR 1690 (22003): DECIMAL value is out of range in '(99999999999999999999999999 * 99999999999999999999999999999999999999999999999999999999)'
mysql> select pow(1000,1000);
ERROR 1690 (22003): DOUBLE value is out of range in 'pow(1000,1000)'
[MYSQL] select multiple columns without comma (0) | 2020.05.24 |
---|