On Thu, Aug 05, 2004 at 12:36:55PM +0100, Naran Hirani wrote: > Hi, > > I'm using a single shared user-login for a web-based application to > my mysql database - is there a way of including some information at > connect time or during processing that would show up when issuing > `show processlist'?
Only if you prefixed each query with a comment: /* foo #3 */ SELECTL * FROM world ORDER BY... But not at connect time. > Basically, I need to able to distinguish potentially multiple > connections with the same login and process information some how. > This sort of thing is possible in other SQL engines so probably > should be in MySQL too. Interesting. How do other systems handle this? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]