1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Rep Power
    Is there a way to know the number of rows
    in a table without using the SELECT * ...?
    I'm looking for some function that only returns the number o rows without reading
    througt all the table.

    Carlos Sala.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    select count(*) from tablename;

Similar Threads

  1. Replies: 5
    Last Post: February 13th, 2004, 02:58 PM
  2. League table problem
    By silverduck in forum MySQL Help
    Replies: 8
    Last Post: February 10th, 2004, 12:38 PM
  3. Inserting multiple rows to mysql table
    By Roaddust in forum PHP Development
    Replies: 6
    Last Post: February 4th, 2004, 08:28 AM
  4. how to keep table on top, not centered??
    By vinyl in forum HTML Programming
    Replies: 2
    Last Post: January 20th, 2004, 06:19 PM
  5. Replies: 7
    Last Post: January 14th, 2004, 08:53 PM

IMN logo majestic logo threadwatch logo seochat tools logo