Home > Database > phpMyAdmin > body text

How to establish foreign key constraints using phpmyadmin

王林
Release: 2019-12-09 14:29:12
Original
3319 people have browsed it

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!

source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!