Hello.
I run the query. At the end gives me a warning message. What kind of warning? Where can I see?
--------------------
Привет.
Я выполняю запрос. В конце мне выдаёт сообщение с предупреждениями. А какие предупреждения? Где можно посмотреть?
Warnings request
I suggest you call
mysql.exe -h yourserver -u yourdbuser -p -D yourdatabase
which will query for your dbpassword. after the prompt appears (... [yourdatabase]> ), type in your query that generated the warnings, followed by a semicolon and enter.
when the prompt appears again, type in
show warnings;
followed by enter. this should show the warnings generated by the first query in cleartext.
mysql.exe -h yourserver -u yourdbuser -p -D yourdatabase
which will query for your dbpassword. after the prompt appears (... [yourdatabase]> ), type in your query that generated the warnings, followed by a semicolon and enter.
when the prompt appears again, type in
show warnings;
followed by enter. this should show the warnings generated by the first query in cleartext.
Through the console did see an error.
Example: "Unknown table 'qqq_table'"
A warning is generated if:
If you use IF EXISTS, then a warning is created.
In HeidiSQL warning is not displayed!
Example: "Unknown table 'qqq_table'"
A warning is generated if:
DROP DATABASE IF EXISTS `lotos-cms`;
CREATE DATABASE IF NOT EXISTS `lotos-cms` ;
USE `lotos-cms`;
DROP TABLE IF EXISTS `lts_banners`;
If you use IF EXISTS, then a warning is created.
In HeidiSQL warning is not displayed!
Please login to leave a reply, or register at first.