List:General Discussion« Previous MessageNext Message »
From:Jay Miller Date:April 14 1999 8:30pm
Subject:RE: ALTER TABLE again
View as plain text  
If you have one varchar in a table, MySQL converts other char fields to
varchar since each record is variable-length anyway.

> -----Original Message-----
> From: efrazier@stripped [mailto:efrazier@stripped]
> Sent: Wednesday, April 14, 1999 3:17 PM
> To: mysql@stripped
> Subject: ALTER TABLE again
>
>
> 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
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread1853@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>

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