[SOLVED] different select statement for number of rows

[atomicrabbit]

I found this http://kids-n-fun.blogspot.com/2006/12/query-number-of-rows-sql-server.html and was wondering how to use it.

 

The select statement is this:

SELECT rows FROM sys.sysindexes WHERE (id = OBJECT_ID('tablename')) AND (name = 'PrimaryKey name')

 

And apparently it's quicker becuase you "select only one row". But after replacing 'tablename' and 'PrimaryKey name' with the appropriate information, the query came back with an error (#1064). I also tried replacing sys.sysindexes with my_db_name.tablename but it still did not work. What am I doing wrong?

[atomicrabbit]

anyone?

[severndigital]

are you using MySQL or SQL??

 

The title of that post is number of rows in SQL query.

 

Not sure if it matters, but the way that query is formatted it will never work properly in my experiences with MySQL.

[atomicrabbit]

ahhhh... that makes sense... I'm using MySQL.

 

so is the easiest/quickest way to return the number of rows in MySQL to do a SELECT count(*) as num FROM table_name ?

 

btw, Thanks for the reply

[fenway]

so is the easiest/quickest way to return the number of rows in MySQL to do a SELECT count(*) as num FROM table_name ?

yes.

[atomicrabbit]

thanks!