Two methods to count the number of rows in the Mysql database

Some time ago, Era shared with you a Mysql database repeat detection function. For how to use this function, you can move to "Repeat detection function when mqsql data is stored in the database-php". today we will introduce two methods to count the number of rows in the Mysql database. Method 1: Use the statistical function count (); $ rsmysql_query (selectcount (*) FROMtm

Some time ago, Era shared with you a Mysql database repeat detection function. For how to use this function, you can move to "Repeat detection function when mqsql data is stored in the database-php". today we will introduce two methods to count the number of rows in the Mysql database. Method 1: Use the count (); $ rs = mysql_query ("select count (*) FROM tm

Some time ago, Era shared with you a Mysql database repeat detection function. For how to use this function, you can move to "Repeat detection function when mqsql data is stored in the database-php". today we will introduce two methods to count the number of rows in the Mysql database.

Method 1: Use the count () statistical function ();

$ Rs = mysql_query ("select count (*) FROM tmp_url"); $ firnnum = @ mysql_result ($ rs, 0); // query the number of rows in a temporary table

Method 2: Use the php Mysql system function mysql_num_rows ();

$ Rs = mysql_query ("select * FROM tmp_url"); $ firnnum = mysql_num_rows ($ rs );

Well, you can choose the specific method.

Original article address: two ways to count the number of rows in the Mysql database. Thank you for sharing it with the original author.