RE: MySQL statement for changing a column name with an illegal character

> From: owner-micronet-list_at_lists.berkeley.edu [mailto:owner-micronet-
> list_at_lists.berkeley.edu] On Behalf Of Aaron DuBois
> Sent: Tuesday, October 02, 2007 11:40 AM
> To: micronet-list_at_listlink.berkeley.edu
> Subject: [Micronet] MySQL statement for changing a column name with an
> illegal character> Alter Table faculty Change `E-mail` email varchar;
>
> is not working.

Fully specify the column. What was `e-mail` originally? Nullable? length
60? Any defaults? So for example:

ALTER TABLE faculty CHANGE COLUMN `e-mail` email varchar(60) NULL;

Paul

------------------------------------------------------------------------
The following was automatically added to this message by the list server:

To learn more about Micronet, including how to subscribe to
or unsubscribe from its mailing list and how to find out
about upcoming meetings, please visit the Micronet Web site:

http://micronet.berkeley.edu/

Messages you send to this mailing list are public and world-viewable,
and the list's archives can be browsed and searched on the Internet.
This means these messages can be viewed by (among others) your bosses,
prospective employers, and people who have known you in the past.
Received on Tue Oct 02 2007 - 12:40:47 PDT