DELETE record mysql

Question

I have a table as an image below

I want to delete all records which have where condition but it's error

MYSQL query

DELETE FROM `DiseaseLogs` 
WHERE `UserId` = '098935f0-ef88-11eb-9baa-e9fb6cd272ad' 
       AND `logType` = 'vaccine' 
       AND `id` NOT IN (130 , 139)

Error: #1205 - Lock wait timeout exceeded; try restarting transaction

Does this answer your question? [How to debug Lock wait timeout exceeded on MySQL?](https://stackoverflow.com/questions/6000336/how-to-debug-lock-wait-timeout-exceeded-on-mysql) — Timothy Alexis Vass, Jul 29 '21 at 08:12

score 0 · Answer 1 · answered Jul 29 '21 at 08:21

0

try this :

mysql->SHOW PROCESSLIST;
kill xxxx;

and kill which one in sleep. ( replace xxxx with your thread id )

answered Jul 29 '21 at 08:21

Ahmed Abdo

3
3

i don't see any thread id but id so I tried kill 1 Unknown thread id: 1 – poppy Jul 29 '21 at 08:38

DELETE record mysql

1 Answers1