Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to create a relation between two tables using PHPMyAdmin?

Tags:

mysql

phpmyadmin

How to create a relation between two tables using PHPMyAdmin?

like image 883
mouthpiec Avatar asked Mar 31 '10 16:03

mouthpiec

1 Answers

This only works if you use InnoDB as storage engine. Then you have a link Relation view besides Print view:

Relation view

If you click this you get to another site where you can select the relations for all columns that have indecies defined on them (following the pattern table->column).

Link to

like image 56
Felix Kling Avatar answered Sep 21 '22 19:09

Felix Kling
Sign in to Comment

Related questions

Mysql Create Database with special characters in the name
MySQL truncate text with ellipsis
MySQL is not allowing ON UPDATE CURRENT_TIMESTAMP for a DATETIME field
Can I use VARCHAR(32) for md5() values?
Filter by datetime MYSQL formatting
mysql group by and sort each group
Boolean Field in mysql db
Is it possible to make MySQL use an index for the ORDER by 1 DESC, 2 ASC?
Prepared Statement with ON DUPLICATE KEY
MySQL concatenating all columns
Display MySQL uptime in days
Execute INSERT if table is empty?
selecting duplicate IDs in mysql
LEFT JOIN order and limit
Explicitly specify sort order for mysql query?
Group records by both month and year in Rails
Python => ValueError: unsupported format character 'Y' (0x59)
Column not found: 1054 Unknown column laravel
I changed MySQL port in XAMPP, now how do I listen to the new port?
How to setup a connection timeout depending of the user login in MySQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!