Home  >  Article  >  Database  >  How to establish foreign key constraints using phpmyadmin

How to establish foreign key constraints using phpmyadmin

王林
王林Original
2019-12-09 14:29:123283browse

How to establish foreign key constraints using phpmyadmin

Click on the database where you want to add foreign keys

How to establish foreign key constraints using phpmyadmin

Click on the tables that need to create foreign key constraints one by one (I use user as an example)

Click operation

How to establish foreign key constraints using phpmyadmin

Modify the storage engine in the table options (the process of modifying other tables is omitted here) (For tables with foreign key constraints, the storage engine remains consistent )

How to establish foreign key constraints using phpmyadmin

Click on the table where you want to add a foreign key

How to establish foreign key constraints using phpmyadmin

Point structure

How to establish foreign key constraints using phpmyadmin

Click on the associated view

How to establish foreign key constraints using phpmyadmin

Add foreign key

How to establish foreign key constraints using phpmyadmin

Click to save

How to establish foreign key constraints using phpmyadmin

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of How to establish foreign key constraints using phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn