Hi,
I have this table: CREATE TABLE FOR_SALE ( ISBN VARCHAR(10) NOT NULL, STOREID MEDIUMINT(8) UNSIGNED NOT NULL, MYDATE DATE NOT NULL, PRICE SMALLINT UNSIGNED NOT NULL, PRIMARY KEY (ISBN, STOREID, MYDATE) ); When I execute this query: SELECT count(*) FROM FOR_SALE nothing happens. No error message and no promt. The query just hangs. The above query used to work fine. mysql> SHOW PROCESSLIST; +---------+---------+-----------+---------+---------+------+-------------------+-------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+---------+-----------+---------+---------+------+-------------------+ -------------------------------+ | 5393322 | jacob | localhost | jacob | Query | 564 | Waiting for table | Select count(*) from FOR_SALE | | 5394177 | jacob | localhost | jacob | Query | 0 | NULL | SHOW PROCESSLIST | +---------+---------+-----------+---------+---------+------+-------------------+ -------------------------------+ 2 rows in set (0.00 sec) If I create a new table the query works! It seems as if the table is corrupted in some way. I think the table maby have about 20 columns. Anyone have any ideas about this? Thanks, Jacob _________________________________________________________________ MSN Photos är det enklaste sättet att dela ut och skriva ut foton: http://photos.msn.se/Support/WorldWide.aspx --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
