Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

two questions: how to log connection and how to execute as connection

Status
Not open for further replies.

Arrowx7

Programmer
Feb 16, 2005
17
CA
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top