how to know total line on mysql

Discussion in 'MySQL' started by meno, Nov 8, 2009.

  1. #1
    hello all...im need help...
    i want to know total line on my database tabel..how to know that?
    im very newbie on mysql...
     
    meno, Nov 8, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    The following command will tell you the total number of rows in a table, replace table_name with your real table name
    SELECT COUNT(*) FROM table_name
    Code (markup):
     
    mwasif, Nov 8, 2009 IP