delete and lock table

[Anon]

I have to delete some rows from a table.
Before deleting do I have to lock my table?

With the updates I know the lock is automatic.

thanx,
saintex

[brandonschnell]

anything that modifies the table will lock the table. including the delete

be careful of using a SELECT statment then an UPDATE/DELETE statement that relies on the result of the SELECT statement

[torres]

Brandon, do you mean, that I've to lock my tables, if e.g. I make an insert into a table, select the primary key of the new data and make an insert with this primary key into another table?

[Anon]

Thank you for your answer, Brandon.

What about the Torres's question?

bye