如果表A中包含的值被删除，如何将表B值（包括在表A中）更改为0

Question

How to solve this problem (mysql table): What PHP code or MySQL that I need to use (when I delete adminid = 1 from table A, the value of adminid table B should change to 0)? Is it possible?

Table A has:

adminid = 1
adminname = jack

Table B has:

newsid = 1
adminid = 1

The TableB.adminid should change to 0 if TableA.adminid = 1 gets deleted.

Thanks!

Answer 1

Through PHP and MySql it's possible if the adminid is not a foreign key in table B (In relationship with table A). Instead of 0 you can make it to null using mysql. There is a SQL command you need to use to enable it: ON DELETE SET NULL.
Refer this for more detail