Steven Why do you include the field name in your FROM part ? The syntax is SELECT fields FROM table
I guess that could be the reason. Try with : SELECT * FROM `traffic` LIMIT 132947 Freddie -----Original Message----- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 26. Juni 2003 20:07 To: Steven Dowd; [EMAIL PROTECTED] Sounds like a corrupt table, try REPAIR TABLE: http://www.mysql.com/doc/en/REPAIR_TABLE.html Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Steven Dowd [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 11:13 AM > To: [EMAIL PROTECTED] > Subject: error message > > > > can someone help me with this error, with my database in MySQL 3.23.49 > > ======================== > SQL-query : > SELECT * > FROM `traffic`.`trafficdb` > LIMIT 132947 > MySQL said: > > Got error 127 from table handler > > ======================== > > have I lost the data, or is there something odd happened which i > should be able to fix? > > Steven Dowd > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
