Re: easy question, what is MUL
On Fri, Jul 27, 2001 at 09:29:20PM -0700, Michael Collins wrote: I have a table that shows MUL in the key field column, what does that indicate? That means it's a non-unique key. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 41 days, processed 328,560,531 queries (90/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: easy question, what is MUL
At 11:08 PM -0700 7/27/01, Jeremy Zawodny wrote: I have a table that shows MUL in the key field column, what does that indicate? That means it's a non-unique key. Thank you, but what does MUL stand for? Multiple keys? I suppose it is a key since I created an index on that field. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
easy question, what is MUL
I have a table that shows MUL in the key field column, what does that indicate? +--+--+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-++ | ID | smallint(5) unsigned | | PRI | NULL| auto_increment | | ModifiedLast | timestamp(14)| YES | | NULL|| | CreationDate | datetime | YES | | NULL|| | FirstName| varchar(64) | YES | | NULL|| | LastName | varchar(64) | YES | MUL | NULL|| | BirthDate| date | YES | | NULL|| | PaidAmount | float(6,2) | YES | | 0.00|| | PaidFlag | tinyint(4) | YES | | 0 || +--+--+--+-+-++ 8 rows in set (0.02 sec) This is how it is defined: CREATE TABLE web ( ID smallint(5) unsigned NOT NULL auto_increment, ModifiedLast timestamp(14) NOT NULL, CreationDate datetime default NULL, FirstName varchar(64) default NULL, LastName varchar(64) default NULL, BirthDate date default NULL, PaidAmount float(6,2) default '0.00', PaidFlag tinyint(4) default '0', PRIMARY KEY (ID), KEY LastName (LastName) ) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php