List:General Discussion« Previous MessageNext Message »
From:efrazier Date:April 14 1999 8:16pm
Subject:ALTER TABLE again
View as plain text  
Hi, 

I did this,

mysql> ALTER TABLE firstdownload CHANGE email 
    -> email VARCHAR(255);
Query OK, 2061 rows affected (0.29 sec)
Records: 2061  Duplicates: 0  Warnings: 0

mysql> explain firstdownload;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| seshID    | int(11)      |      | PRI | 0       | auto_increment |
| _index    | smallint(6)  | YES  |     | NULL    |                |
| email     | varchar(255) | YES  |     | NULL    |                |
| name      | varchar(255) | YES  |     | NULL    |                |
| browser   | varchar(255) | YES  |     | NULL    |                |
| web_email | varchar(30)  | YES  |     | NULL    |                |
| DT        | datetime     | YES  |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

The thing is I am not 100% certain, but I could swear the name and browser
and web_email fields were CHARs. Could I have done something weird? 

Thanks again,

Eric 

Thread
ALTER TABLE againefrazier15 Apr
  • RE: ALTER TABLE againJay Miller15 Apr