3 ms·
I've never had the privilege of using PostgreSQL but when using MySQL, I always enable automatic display of warnings (which really should be errors): mysql
by Anthony-G 8y ago
I've never had the privilege of using PostgreSQL but when using MySQL, I always enable automatic display of warnings (which really should be errors):
mysql> \W
Show warnings enabled.
mysql> select 0 = 'banana';
+--------------+
| 0 = 'banana' |
+--------------+
| 1 |
+--------------+
1 row in set, 1 warning (0.00 sec)
Warning (Code 1292): Truncated incorrect DOUBLE value: 'banana'