Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Difference b/w Count(*) and * in Mysql

What is difference between select * from tbl_name  dand select count(*) from tbl_name    ?

There is difference b/w select * and count (*) in the result value. The select * from tbl_name is show the all value or content in the table and select count(*) is show the no of values or content in the give tables.