PhpMyAdmin cascade deletion, MySQL

Copyright statement: original works can be reproduced. During reprinting, you must mark the original publication, author information, and this statement in hyperlink form. Otherwise, legal liability will be held. Http://blog.csdn.net/mayongzhan-ma yongzhan, myz, mayongzhan

 

Good stuff in the database

The method of cascading deletion in phpMyAdmin.

First, two tables are required.

One Table user

Id username userpassword

One Table user item table thing

Id uid things

 

The purpose is to delete a piece of data in the User table and the data related to the user in the user item table.

 

Set UID to index in user item table

 

Then there is a link below to view

 

In the UID row, user-> ID on Delete, cascade

 

OK

You can try it.