In MySql we can count the total number of records by using count(1) or count(*).
Is there any technical difference between them?
migrated from programmers.stackexchange.com Aug 18 '12 at 10:41
This question came from our site for professional programmers interested in conceptual questions about software development.
all return the count.
Edit In fact, in SQL Server, a
and at least one exception is
FWR in MySQL