On Sat, 16 Mar 2002 23:03:48 +0800 ±i®p»Ê <[EMAIL PROTECTED]> wrote:
> Hi,all friends: > > Would you please tell me which script in MySQL is fast? > --------------------------------------------- > 1. select count(*) from bk_data Never use * > 2. select count(book_name) from bk_data always specify fields you need. mysql does not have to look for fields definitions, and last but not least, your query will more readable :). pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php