LATEST N RECORDS from a table without date field

2005-08-24 Thread Praveen KS
Can anyone help with a query to retrieve latest N records. No auto_increment field. No date field. Primary key exists and is populated with random unique values. Eg: slno int(10) primary key (populated with random unique values) name char(20) Thanks in advance. PraveenKumarKS http://www.geoci

MyISAM vs InnoDB ----- Incorrect key file for table error

2005-07-08 Thread Praveen KS
Hi, In a table of 20,000 records I am frequented with this error: Error 1034: Incorrect key file for table: ''; try to repair it Frequency of this error: Three or four times a week. I am logging the data it was trying to insert or update. After I, repair table if, I try to insert the sam