Is there any difference between mysql count(*), count(1) and count(column)?

  mysql, question

as the title says
I want to ask, which is better?

count(1)withCount (primary key)Similarly, only the primary key is scanned.count(*)withCount (not primary key)Similarly, scan the entire table. Obviously, the former is faster.

Data support is too lazy to do it again. The number of records is too small to see. Please quote a previous data.
Count (*), the difference between count (1) and count (primary key)On the 6th floor.

SQL> select count(*) from ysgl_compile_reqsub;
 
 COUNT(*)
 ----------
 5288265
 
 Time Used: 00: 00: 07.51
 SQL> select count(1) from ysgl_compile_reqsub;
 
 COUNT(1)
 ----------
 5288265
 
 Time Used: 00: 00: 00.68
 SQL> select count(id) from ysgl_compile_reqsub;
 
 COUNT(ID)
 ----------
 5288265
 
 Time Used: 00: 00: 00.68
 SQL> select count(rowid) from ysgl_compile_reqsub;
 
 COUNT(ROWID)
 ------------
 5288265
 
 Time Used: 00: 00: 01.01