Haven’t done any sneaky puzzles in a while. How would you accomplish this?
mysql> CREATE TABLE t1 (id int); Query OK, 0 rows affected (0.08 sec) mysql> INSERT INTO t1 VALUES (1); Query OK, 1 row affected (0.02 sec) mysql> SELECT COUNT(*) FROM t1; +----------+ | COUNT(*) | +----------+ | 2 | +----------+ 1 row in set (0.00 sec)