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

    Join Date
    Sep 2000
    Location
    saltillo,Coahuila,Mexico
    Posts
    5
    Rep Power
    0
    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
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    select count(*) from tablename;

Similar Threads

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

IMN logo majestic logo threadwatch logo seochat tools logo