Friday, January 14, 2011

mysql alter table column name

mysql> alter table compounds change CASNumber CAS varchar(15);
at

1 comment:

  1. Tech NotesMarch 18, 2011 at 9:26 AM

    rename table
    mysql> rename table be_internal to be_external

    Delete a column from an existing MySQL table
    mysql> alter table be_internal drop Spec;

    ReplyDelete

Subscribe to: Post Comments (Atom)