Where the open source database community meets: Use code PERCONA75 and secure your spot for Percona Live. Register

Downloads

Blog

Contact Us

MySQL 5.1 Command line client improvements

June 16, 2007

Author

Peter Zaitsev

Insight for Developers

Share this Post:

Just found this little handy feature today:

mysql&gt; insert into c select rand()*1000, sha1(rand()) from c;
Query aborted by Ctrl+C
ERROR 1317 (70100): Query execution was interrupted

1

2

3

mysql> insert into c select rand()*1000, sha1(rand()) from c;

Query aborted by Ctrl+C

ERROR 1317 (70100): Query execution was interrupted

So now if you press CTRL-C MySQL Command Line Client will not exit but will terminate query being executed. This is great as so many queries assumed CTRL-C would also abort running query in previous MySQL versions and I’ve seen many monstrous queries left running without noticing just because people would think CTRL-C terminated the query. Now it finally really does.

Great Job! I wish I would see more of such relatively simple but very handy improvements 🙂