RE: Error : Incorrect key file for table 'X'

2009-04-25 Thread Mark
C'mon, guys, there's gotta be someone who knows something about this. :) Anyone? Anyone? Bueller? Bueller? I even did a complete mysqldump (from the 5.0.77 mysqld) and imported it that way. To no luck, alas. Thanks, - Mark -Original Message- From: Mark [mailto:ad...@asarian-host.net] S

Ordering cars

2009-04-25 Thread Olav Mørkrid
Say I have a table with any number of car brands, with belonging street dates. Is it possible to do the following type of sort in a single query? 1. First I want the newest model of all car brands, but only one of each brand! And they should be ordered by year 2. Then I want the cars that weren'