• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Finding the total row of my table.

 
Jeffry Kristianto Yanuar
Ranch Hand
Posts: 759
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys, My name is jeffry. I have a little problem regarding of my database.

How can I retrieve the total rows of my table? I use MySQL 5.0 and I want to know the sql syntax to know many rows are in my table assuming that my database name is "dvdrental" and my table name is "dvd".


Thanks a lot.


Jeffry Kristianto Yanuar
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe,

should work.

The better would be


Cheers.
 
Jeffry Kristianto Yanuar
Ranch Hand
Posts: 759
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
OK, thanks for the reply.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic