Just found this little handy feature today:
PLAIN TEXT
SQL:
- [FONT='Courier New', Courier, monospace]mysql> INSERT INTO c SELECT rand()*1000, sha1(rand()) FROM c;[/font]
- [FONT='Courier New', Courier, monospace]Query aborted BY Ctrl+C[/font]
- [FONT='Courier New', Courier, monospace]ERROR 1317 (70100): Query execution was interrupted [/font]
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
MySQL 5.1 Command line client improvements - Read More...