Web Development

To modify a Foreign Key in MySQL follow this steps :
1) Show table to see what is the name of Foreign Key we want to delete

SHOW CREATE TABLE table


2) Delete the Foreign Key

ALTER TABLE table DROP FOREIGN KEY table_ibfk_x


3) Create the new Foreign Key

ALTER TABLE table ADD CONSTRAINT `table_ibfk_x` FOREIGN KEY (`Field_id`) REFERENCES `references_table` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION


MySQL foreign keys, MySQL

In config file ( config.inc.php) you can’t set $cfg['Servers'][$i]['only_db'] = ‘my_db‘ . It will return NO DATABASES FOUND

$cfg['Servers'][$i]['only_db']

If set to a (an array of) database name(s), only this (these) database(s) will be shown to the user. Since phpMyAdmin 2.2.1, this/these database(s) name(s) may contain MySQL wildcards characters (“_” and “%”). If you want to use literal instances of these characters, escape them .

use 'my\_db' and not 'my_db'

MySQL, PHP