0

This not phpmyadmin feature enhancement for internal relationships. I am using InnoDB.

I want to know how to Phpmyadmin create select value from foreign key.

This is example :

enter image description here

I have used a foreign key in PhpMyAdmin, I am very curious, how PhpMyAdmin can detect the options that have been used for the foreign key. I have some experiments with selecting data in INFORMATION_SCHEMA and it took a long time to load it, is there any way to get the foreign key value only with MySQL query?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Abdul Aziz Al Basyir
  • 1,104
  • 13
  • 28
  • 1
    Please add the code you used to access the 'INFORMATION_SCHEMA' schema to get the foreign key. maybe interesting? https://stackoverflow.com/questions/4159998/how-can-i-get-the-foreign-keys-of-a-table-in-mysql – Ryan Vincent Sep 29 '17 at 14:59
  • Thanks, my question is duplicated, that ismy answer, @RyanVincent – Abdul Aziz Al Basyir Sep 30 '17 at 01:20

0 Answers0