AW: why different users get different count(*) from same table?

Check your rights ;) -Ursprüngliche Nachricht- Von: jinava [mailto:jin...@gmail.com] Gesendet: Mittwoch, 1. Juli 2009 14:52 An: mysql@lists.mysql.com Betreff: Re: why different users get different count(*) from same table? Hi experts, Something strange here, use root and mysql (root

Re: why different users get different count(*) from same table?

Hi experts, Something strange here, use root and mysql (root and mysql are user accounts) to select count(*) from same table, but the result is different. login as root: mysql -uroot -p information_schema mysql> select * from tables where table_name='tb_staff'\G *** 1. r

why different users get different count(*) from same table?

Hi experts, something strange here, use root and mysql (root and mysql are user accounts) to select count(*) from same table, but the result is different. login as root: mysql -uroot -p information_schema mysql> select * from tables where table_name='tb_staff'\G *** 1. r