Hi Krasimir, I used this query and it helped me:
SHOW TABLE STATUS LIKE 'mytable' the query that you told me is good if I want to find the number of records in a subset of a table. I can use it in somewhere else. thanks a lot for your help. ----- Original Message ----- From: "Krasimir_Slaveykov" <[EMAIL PROTECTED]> To: "Mojtaba Faridzad" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 9:22 AM Subject: Re: the number of Rows (records) > Hello Mojtaba, > > Monday, July 14, 2003, 3:57:42 PM, you wrote: > > try this: > select count(*) from TableName > > > > > MF> Hi, > > MF> Is there any command or function in MySQL to find out how many records a > MF> table has? phpMyAdmin shows the number of records ( Rows ) when shows the > MF> structure of a table plus Row Length more information. How can we find these > MF> table information? > > MF> Thanks > > > > > > > -- > Best regards, > Krasimir_Slaveykov mailto:[EMAIL PROTECTED] > Tel: ++359 2 97 666 [EMAIL PROTECTED] > Tel: ++359 2 97 66 701 > Fax: ++359 2 97 66 731 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]