Problem executing MySQL delete statement

[usamaalam]

Hello everybody,

When I run the following statement, it returns 3660 rows.

select * from symbols where code = 'AAHSY00';

But when I run the following statement, it doesn't do anything and goes in a never ending loop.

delete from symbols where code = 'AAHSY00';

Any idea on how to fix this?

Thanks.

[PeejAvery]

There's nothing wrong with the query strings. Have you tried to add a LIMIT to it just to test it out?

[Shuja Ali]

Nothing wrong with the query. Might be that the table is locked by some other process.