Magic tricks

[dormando]

mysql> CREATE TABLE `blah2` ( `hello` int(11) default NULL );
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO blah2 VALUES (1);
Query OK, 1 row affected (0.00 sec)

mysql> select * from blah2;
+-------+
| hello |
+-------+
| 1 |
| 1 |
+-------+
2 rows in set (0.00 sec)

mysql> show full processlist;
+--------+-------+-----------------+------+---------+------+----------------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-------+-----------------+------+---------+------+----------------+-----------------------+
| 503235 | root | localhost | NULL | Sleep | 742 | | NULL |
| 503238 | happy | localhost:36013 | test | Query | 0 | NULL | show full processlist |
| 503239 | happy | localhost:36014 | test | Query | 0 | Writing to net | show full processlist |
+--------+-------+-----------------+------+---------+------+----------------+-----------------------+
3 rows in set (0.00 sec)

mysql> use sakila;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show full processlist;
+--------+-------+-----------------+--------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-------+-----------------+--------+---------+------+-------+-----------------------+
| 503235 | root | localhost | NULL | Sleep | 801 | | NULL |
| 503238 | happy | localhost:36013 | sakila | Query | 0 | NULL | show full processlist |
| 503239 | happy | localhost:36014 | sakila | Sleep | 17 | | NULL |
+--------+-------+-----------------+--------+---------+------+-------+-----------------------+
3 rows in set (0.00 sec)

Easy.