Warnings request

[expired user #7490]'s profile image [expired user #7490] posted 9 years ago in General Permalink
Hello.
I run the query. At the end gives me a warning message. What kind of warning? Where can I see?


--------------------

Привет.
Я выполняю запрос. В конце мне выдаёт сообщение с предупреждениями. А какие предупреждения? Где можно посмотреть?

jfalch's profile image jfalch posted 9 years ago Permalink
translate to english. most people here cannot read russian (or whatever that is).
[expired user #7490]'s profile image [expired user #7490] posted 9 years ago Permalink
Warning
Your inquiry has made 81
warning.
Warning last request:
jfalch's profile image jfalch posted 9 years ago Permalink
does it show any warnings in the log pane (bottom) ?

if not, please repeat your query after putting

; show warnings;

at the end.
[expired user #7490]'s profile image [expired user #7490] posted 9 years ago Permalink
that's what shows upon request



/ * Affected rows: Found 645 line 0 Warning: 81 Duration 398 queries: 9,468 sec. * /
jfalch's profile image jfalch posted 9 years ago Permalink
hm. that did not work.
what kind of system are you on (windows, linux, mac) ?
do you already have access to the mysql coammd line client (mysql.exe on win, mysql on others) ?
[expired user #7490]'s profile image [expired user #7490] posted 9 years ago Permalink
OS Windows7
I use WAMP OpenServer
have access to mysql
jfalch's profile image jfalch posted 9 years ago Permalink
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.
[expired user #7490]'s profile image [expired user #7490] posted 9 years ago Permalink
Through the console did see an error.
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.unhappy

In HeidiSQL warning is not displayed!

Please login to leave a reply, or register at first.