From: Ananda Kumar Date: June 17 2010 9:37am Subject: Re: why the sql so slowly? List-Archive: http://lists.mysql.com/mysql/221945 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=001636e1f8467f89bc0489369663 --001636e1f8467f89bc0489369663 Content-Type: text/plain; charset=ISO-8859-1 you want to select all rows from the table On Thu, Jun 17, 2010 at 2:05 PM, hewei wrote: > 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; > ------------------------------- > --001636e1f8467f89bc0489369663--