When we enter any wrong value and then it will run, then it will show a warning. By using this query we can show warning details.
For example - when we enter a String value in the place of an integer value (in column id) then it will run but show a warning. then we will check why the warning showed by the below query.
show warnings ;