MariaDB [test]> create table foo (c_foo integer);
Query OK, 0 rows affected (0.46 sec)

MariaDB [test]> select count (*) from foo;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*) from foo' at line 1
MariaDB [test]> select count(*) from foo;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

MariaDB [test]>