Re: How to sort on multiple columns?

2002-06-07 Thread Victoria Reznichenko
Tim, Friday, June 07, 2002, 7:05:40 AM, you wrote: TJ I am using TJ mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu TJ on RH 7.2 TJ I would like to sort on multiple columns, but Mysql TJ tells my that the specified key would be too long TJ (error 1071). TJ If

How to sort on multiple columns?

2002-06-06 Thread Tim Johnson
Hello All: I am using mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu on RH 7.2 I would like to sort on multiple columns, but Mysql tells my that the specified key would be too long (error 1071). If this is the case, what might be an alternative strategy?

Re: How to sort on multiple columns?

2002-06-06 Thread Chris Knipe
describe CL0420; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | ID | int(11) | YES | | 0 | | | Producer | char(255) | YES |