Hello,
Two questions, if you guys would be so kind as to address:
1. How do I log only a certain connection? I know I can log the current connection using "\T filename" option, but I am more interested in logging another connection knowing its ID. Perhaps I can switch the current connection to the one I want and use the \T option? (which leads me to the next question)?
2. Is it possible to execute a query THROUGH ANOTHER connection using the terminal? Say I log into mysql, it assigns me my own connection, can I, from there, execute a query using one of the other current connections (if its status is "asleep").
Thanks in advance guys!
Two questions, if you guys would be so kind as to address:
1. How do I log only a certain connection? I know I can log the current connection using "\T filename" option, but I am more interested in logging another connection knowing its ID. Perhaps I can switch the current connection to the one I want and use the \T option? (which leads me to the next question)?
2. Is it possible to execute a query THROUGH ANOTHER connection using the terminal? Say I log into mysql, it assigns me my own connection, can I, from there, execute a query using one of the other current connections (if its status is "asleep").
Thanks in advance guys!