MUL indicates a that the column is part of a composite INDEX. SHOW INDEX FROM tablename
Should let you know what columns make up the MUL column INDEX. If this was not supposed to be indexed, your table is corrupt, best try MyIsamChk Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 3:13 PM > To: [EMAIL PROTECTED] > Subject: Strange "Mull" in show fields and table keeps crashing > > > Hello, > I have this table: > "CLUB" > Field Type Null Key Default Extra > clubid int(11) PRI NULL auto_increment > clubusgf int(11) UNI 0 > program char(3) > url varchar(75) > email varchar(75) > phone varchar(14) > fax varchar(14) > address1 varchar(75) MUL > address2 varchar(75) > city varchar(75) > notes varchar(255) > zip varchar(10) > clubname varchar(75) > contact_primary varchar(40) > state char(2) > contact_secondary varchar(40) > > > See address1 above the the "MUL" next to it. What is that? > Also, this > table keeps crashing, it crashes when I make an edit to > anything in this > field. So I copy the column, move the data over and then I > can make edits > in this field. However, another field in my table will get > this strange > "MUL" indication. From this point forward then, any changes > to the data in > that column will cause the table to crash. > I've succesfully repaired the table a 1/2 dozen times or so... and > copied/renamed about 4 of the columns as they took on this "MUL" > characteristic. > Any ideas how to fix this problem? Any ideas what is going on? > > Here is my version of MySQL: > Server version: 4.0.0-alpha > > Karl > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
