On 06/10/2005, "s. keeling" wrote: > Incoming from Arno Coetzee: > > s. keeling wrote: > > > alter table MEMBERS > > > alter MEMBER_INFO varchar(160); > > > > > > ERROR 1064: You have an error in your SQL syntax. > > > > http://dev.mysql.com/doc/mysql/en/alter-table.html > > Yes, I've read it. Your point? Specifically?
If I read the manual (refered to above) correctly, the only thing you can put after "alter table MEMBERS alter MEMBER_INFO" is either "SET DEFAULT literal" or "DROP DEFAULT". I think you have to use ALTER TABLE MEMBERS CHANGE MEMBER_INFO MEMBER_INFO VARCHAR(160) ...; with ... optionally NOT NULL and/or DEFAULT 'whatever' -- felix -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]