Re: why the sql so slowly?

you want to select all rows from the table? ===> YES

Re: why the sql so slowly?

1.How many records are there in this table. ==>6000 rows. 2.What is the select statement ur running. ==> --- I need to select the table 'table_code' per minute,and the sql is like : select code from table_code; ---

why the sql so slowly?

now , I need to select a table per minute. 1. the table struture: - CREATE TABLE `table_code` ( `timestamp` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `code` decimal(5,0) NOT NULL default '0', PRIMARY K