mysql - Foreign Key is not Updating with the primary key of other table -


i added primary key named "loc_id" in location_table. , in employee_table, making 'loc_id' foreign key. doing in wamp "innodb" set in both tables , on delete cascade , on update cascade set.

i inserting value in "loc_id" column of location table value inserting not reflecting in employee table even-though set foreign key in employee_table.

example :

i inserting value "101" primary key in "loc_id" column of location_table, think since have made "loc_id" column foreign key on update cascade on in employee_table, value should automatically reflects/show in loc_id column of employee_table.

can me in this??


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -