How to find original row count in MySQL?

[Willington]

The following query returning the following result: SELECT count(*) FROM `table1`; -------------------- Resilt 2000 But the following Query returning different result SELECT table_name, table_rows AS rows FROM information_schema.tables WHERE table_schema = 'bakrol14' and table_name = `table1` Order by table_name; -------------------- Result 2143 What is the reason?

[scottgp]

I'm not really familiar with MySQL, but Googling for table_rows shows some possible issues. See the first two here:http://www.google.com/search?q=table_rows&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a[^]