How to check updated rows in mysql

Question

I'm a MySQL beginner. Does anybody know what the sql statment is to read how many recods their are in a MySql database? I don't want to display the records i just want to know how many records their are in my table.

Thanks

DJ

possible duplicate of [MySql count table rows](http://stackoverflow.com/questions/1893424/mysql-count-table-rows) — Sadikhasan, Jun 28 '14 at 07:14

score 0 · Answer 1 · answered Jun 28 '14 at 06:59

0

You can use count(*) to get count of records in your table,as given below

Select count(*) from your_table

answered Jun 28 '14 at 06:59

mahesh

1,311
1
13
26

How to check updated rows in mysql

1 Answers1