Re: why the sql so slowly?

2010-06-17 Thread hewei
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; ---

Re: why the sql so slowly?

2010-06-17 Thread Ananda Kumar
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

Re: why the sql so slowly?

2010-06-17 Thread hewei
you want to select all rows from the table? ===> YES

MySQL Community Server 5.1.48 has been released

2010-06-17 Thread Karen Langford
Dear MySQL users, MySQL Community Server 5.1.48, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.48 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mys

Re: opening a server to generalized queries but not "too" far

2010-06-17 Thread Raj Shekhar
In infinite wisdom don-mysq...@isis.cs3-inc.com (Don Cohen) wrote: > The question is what I have to prohibit in order to prevent either > updates or access to other tables, or perhaps other things that > I should be worried about but haven't yet thought of. One option here might be to use "mysq