List:General Discussion« Previous MessageNext Message »
From:Héctor Villafuerte D. Date:November 24 2003 8:06pm
Subject:Warnings in CREATE TABLE
View as plain text  
Hi all,
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)


Thread
Warnings in CREATE TABLEHéctor Villafuerte D.24 Nov
  • Re: Warnings in CREATE TABLEHéctor Villafuerte D.24 Nov
    • What's bestSale Zenzo24 Nov
      • Re: What's bestKenn Murrah24 Nov
        • Re: What's bestSale Zenzo24 Nov
      • Re: What's bestJulian Zottl24 Nov
Re: What's bestjeffrey_n_Dyke24 Nov
  • Re: What's bestMartijn Tonies24 Nov