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_Slaveykovmailto:[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]
Re: the number of Rows (records)
Hello Mojtaba, Monday, July 14, 2003, 3:57:42 PM, you wrote: If you want you can use /with Windows OS/ MySQL-Front to see some additionall information for tables and to use it for work area for some jobs. 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_Slaveykovmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: the number of Rows (records)
SELECT COUNT(*) FROM table_name; [EMAIL PROTECTED] wrote: Hi, Is there any command or function in MySQL to find out how many records a table has? phpMyAdmin shows the number of records ( Rows ) when shows the structure of a table plus Row Length more information. How can we find these table information? Thanks -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: the number of Rows (records)
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_Slaveykovmailto:[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]