get the thread identity : Show « Command MySQL « SQL / MySQL

1. SQL / MySQL
2. Command MySQL
3. Show

get the thread identity

       
mysql> SHOW PROCESSLIST;
+----+------+-----------------+------+---------+------+-------+------------------+
| Id | User | Host            | db   | Command | Time | State | Info             |
+----+------+-----------------+------+---------+------+-------+------------------+
|  3 | root | localhost:50274 | test | Query   |    0 | NULL  | SHOW PROCESSLIST |
+----+------+-----------------+------+---------+------+-------+------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
    
    
    
    
  

Related examples in the same category