简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

phpMyAdmin中设置外键

WBOY
Release： 2016-06-07 17:12:13
Original
2125 people have browsed it

今天使用到了MySQL数据库，最初使用的可视化管理工具是官方推荐的MySQL GUI Tools。用来一会发现不是很好用，就换phpMyAdmin了，

今天使用到了MySQL数据库，最初使用的可视化管理工具是官方推荐的MySQL GUI Tools。用来一会发现不是很好用，就换phpMyAdmin了，确实要比之前的方便一点，但是在设置外键的时候又不是很方便，如是乎还是决定进入命令行模式，，设置外键的语句如下：

这个时候再打开phpMyAdmin可以看到，外键关系已经设置好了：

phpMyAdmin中设置外键

linux

Related labels：
phpmyadmin database
source：php.cn
Previous article：Oracle 导出移动表空间 Next article：MySQL中对表操作的语法集锦
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
Latest Articles by Author
Latest Issues
How to solve /opt/lampp/bin/mysql.server: line 261: log_success_msg: command not found After installing xampp in my linuxmanjaro, I encountered this error. Previously, even with...
From 2023-11-08 08:46:06
0
1
263
Connect phpMyAdmin to MySQL server via SSL I might be barking up the wrong tree... However, what I have is a MySQL server that only a...
From 2023-10-23 08:57:18
0
2
308
PHP: Import .SQL data files and manage maximum execution time I'm trying to import a large .sql data file using phpMyAdmin in XAMPP. However, this takes...
From 2023-10-15 08:34:47
0
1
230
A guide to migrating a Drupal 9 database to a personal MySQL database When I use a tool like PHPMyAdmin on my own server, the data currently being used with Dru...
From 2023-09-15 10:54:14
0
1
203
MySQL: unexplained date field dependency I'm trying to update the default values ​​of two date fields in an existing database. The ...
From 2023-09-10 22:29:38
0
1
267
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
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！