| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Shankar Unni | Date: | October 21 2001 1:09am |
| Subject: | Length limit of 500 on primary keys? | ||
| View as plain text | |||
Why is there a limit of 500 bytes on the primary key? (MySQL-Max-3.23.43 on WinNT). Is there a way to raise this limit? We have some tables with columns that are VARCHAR(200), and need to make a primary key based on combinations of these columns (in some cases, upto 4 columns), and MySQL complains for all of these table definitions that "Specified key was too long. Max key length is 500". -- Shankar Unni.
| Thread | ||
|---|---|---|
| • Length limit of 500 on primary keys? | Shankar Unni | 21 Oct |
| • RE: Length limit of 500 on primary keys? | Chris Bolt | 21 Oct |
| • RE: Length limit of 500 on primary keys? | Steve Meyers | 21 Oct |
| • Re: Length limit of 500 on primary keys? | Shankar Unni | 22 Oct |
| • RE: Length limit of 500 on primary keys? | Steve Meyers | 22 Oct |
| • Re: Length limit of 500 on primary keys? | Jeremy Zawodny | 23 Oct |
| • RE: Length limit of 500 on primary keys? | Steve Meyers | 23 Oct |
| • RE: Length limit of 500 on primary keys? | Steve Meyers | 23 Oct |
| • Re: Length limit of 500 on primary keys? | Shankar Unni | 24 Oct |
| • Re: Length limit of 500 on primary keys? | Bill Adams | 23 Oct |
| • RE: Length limit of 500 on primary keys? | Steve Meyers | 23 Oct |
| • RE: Length limit of 500 on primary keys? | Don Read | 23 Oct |
| • Re: Length limit of 500 on primary keys? | Dan Nelson | 24 Oct |
| • Re: Length limit of 500 on primary keys? | Heikki Tuuri | 23 Oct |
