try to get EXPLAIN EXTENDED informations
Posted: Sun 17 Apr 2011 16:34
Hi,
is there any way to get the EXPLAIN EXTENDED "warnings" using dbForge for MySQL (4.50.348)? This special warnings don't show in dbForge.
In MySQL Console I get this...
with kind regards
Thomas
is there any way to get the EXPLAIN EXTENDED "warnings" using dbForge for MySQL (4.50.348)? This special warnings don't show in dbForge.
In MySQL Console I get this...
Code: Select all
CREATE TABLE obst (
anzahl INT NOT NULL,
art VARCHAR(20) NOT NULL,
saison VARCHAR(20) NOT NULL
);
INSERT INTO obst VALUES
(1, 'Apfel', 'Sommer'),
(2, 'Apfel', 'Winter'),
(3, 'Bananen', 'Sommer'),
(4, 'Bananen', 'Winter'),
(5, 'Birnen', 'Sommer'),
(6, 'Birnen', 'Winter');
EXPLAIN EXTENDED
SELECT * FROM obst
WHERE anzahl = 1
OR anzahl = 1
OR anzahl = 1;
+----+-------------+-------+------+---------------+------+---------+------+------+----------+----
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Ext
+----+-------------+-------+------+---------------+------+---------+------+------+----------+----
| 1 | SIMPLE | obst | ALL | NULL | NULL | NULL | NULL | 6 | 100.00 | Usi
+----+-------------+-------+------+---------------+------+---------+------+------+----------+----
1 row in set, 1 warning (0.00 sec)
mysql> show warnings;
+-------+------+--------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-----------------+
| Level | Code | Message
|
+-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Note | 1003 | select `sample`.`obst`.`anzahl` AS `anzahl`,`sample`.`obst`.`art` AS `art`,`sample`.`obst`.`saison` AS`saison` from `sample`.`obst` where ((`sample`.`obst`.`anzahl` = 1) or (`sample`.`obst`.`anzahl` = 1) or (`sample`.`obst`.`anzahl` = 1)) |
+-------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
mysql>
Thomas