How to kill multiple process list using command in linux for DB2
0
votes
0
answers
185
views
I connected mysql in linux server using
mysql -u root -p dbnmae
then i use cmd show processlist;
and its showing result like
+---------+------+
| Id | User |
+---------+------+
| 123 | root |
| 1234 | root |
| 1235 | root |
| 1236 | root |
| 1004 | root |
| 1205 | root |
| 1216 | root |
Now I want to kill some process_id (1234,1005,1205) using one command only. When I tried to kill in many ways but its not working properly. Its showing error like a
mysql> kill 1234 1005 1205;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1205' at line 1
Can you please help me to how to solve this issue. This is a DB2 server.
Asked by priyank
(1 rep)
Apr 6, 2023, 02:34 PM