NGA

[MYSQL] make error

2018. 11. 3. 21:39
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)'

 

'DB > MYSQL' 카테고리의 다른 글

[MYSQL] select multiple columns without comma  (0) 2020.05.24

이 글을 공유합시다

facebook twitter googleplus kakaoTalk kakaostory naver band