Anonymous 2333
I think it would be great to `SHOW WARNINGS` as a default option (for MySQL and/or MariaDB).
example fiddle:
https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=98b0eabadcba234d3d1bd472387604e6
```
SELECT 1/0;
SHOW WARNINGS;
```
output:
|1/0|
|--|
||null
|Level |Code |Message|
|--|--|--|
|Warning |1365 |Division by 0|
and
```
SET @i=0;
SELECT @i:=@I+1;
SHOW WARNINGS;
```
output:
|@i:=@I+1|
|--|
|1|
|Level |Code |Message|
|--|--|--|
|Warning |1287 |Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: 'SET variable=expression, ...', or 'SELECT expression(s) INTO variables(s)'.|
and maybe even ERRORS, when doing something like this:
```
WITH RECURSIVE cte1 as (
SELECT 1 as x
union all
SELECT x+1 FROM cte1 WHERE x<1001)
SELECT * FROM cte1;
SHOW ERRORS;
```