Hello all,
How does one stop or abort a query?
I was doing some experimenting with MySQL and created a table with 100,000 records. I then did a join like so:
create table foo select foo.name, foo.val from foo, foo x, foo y, foo z ;
This took a long time. So, I aborted with Ctrl-C (^C) which bumped me out of the mysql client. I then reconnected, issued 'show processlist;', and issued a 'kill ###;' for the process. Is this the way to abort a query? Or is there a more graceful method that aborts the query but keeps me in the mysql client?
Have googled and searched the mailing list archives and faq, but nothing so far. Hints for search terms and pointers to a URL are greatly appreciated.
Regards, - Robert
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
