0

Hi all, i have a problem in writing a block of SQL code in mysql. The block of code will have too delete a single row/record from about 23 related tables all at once.

The code that i have written so far will only delete 1 row/record in 10 related tables but no more. Will not mysql allow this? Can anyone help me?

Thanks to anyone that can help me out.

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by codeblock
0

If your tables are linked through PK / FK, you need to delete from clild table record first and move upwards to parent table records and delete.

0

If your tables are linked through PK / FK, you need to delete from clild table record first and move upwards to parent table records and delete.

Thanks debasisdas, but i still get 0 row(s) deleted. ( Query took 0.0256 sec )

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.