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