Could you please tell me what can be causing this warnings? How can I see them?
My Python script is dying because of this warnings :(
Since I'm using 4.0.16, I can't use SHOW WARNINGS.
Thanks in advance,
Hector
mysql> create table new_web select a.* from otr_new as a join internet as b on a.telefb = b.tel;
Query OK, 25335 rows affected (46.98 sec)
Records: 25335 Duplicates: 0 Warnings: 311
mysql> explain select a.* from otr_new as a join internet as b on a.telefb = b.tel;
+-------+-------+---------------+------+---------+----------+---------+--------------------------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+-------+-------+---------------+------+---------+----------+---------+--------------------------+
| a | index | NULL | tel | 47 | NULL | 3343166 | Using index |
| b | ref | tel | tel | 8 | a.telefb | 11 | Using where; Using index |
+-------+-------+---------------+------+---------+----------+---------+--------------------------+
2 rows in set (0.00 sec)
mysql> select version(); +-----------+ | version() | +-----------+ | 4.0.16-nt | +-----------+ 1 row in set (0.02 sec)
mysql> explain otr_new; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | tel | char(8) | YES | MUL | NULL | | | telefb | char(14) | YES | | NULL | | | rutaentran | char(8) | YES | | NULL | | | rutasalien | char(8) | YES | | NULL | | | minutos | int(7) | YES | | NULL | | +------------+----------+------+-----+---------+-------+ 5 rows in set (0.00 sec)
mysql> explain internet; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | tel | char(7) | YES | MUL | NULL | | | modem | char(30) | YES | | NULL | | +-------+----------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
mysql> explain new_web; +------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+----------+------+-----+---------+-------+ | tel | char(8) | YES | | NULL | | | telefb | char(14) | YES | | NULL | | | rutaentran | char(8) | YES | | NULL | | | rutasalien | char(8) | YES | | NULL | | | minutos | int(7) | YES | | NULL | | +------------+----------+------+-----+---------+-------+ 5 rows in set (0.00 sec)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
