Altering with GUI Mysql workbench 8.xx
I can not alter table with gui. when i select sales customer then foreign keys i can not tick on customer id why?
6 answers ( 0 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
actually you have to give column name for forigen key, then you might be able to select it
Hi Rufat and Abdul!
Thanks for reaching out.
@: Abdul
Thanks for sharing this — it’s always helpful to hear different perspectives!
@: Rufat
Adding a name to the foreign key, as Abdul mentioned, is perfectly okay. The referenced column still needs to be a PRIMARY or UNIQUE key with the same data type for the foreign key to work correctly.
Hope this helps.
Best,
Tsvetelin
Hi again. Thanks mr. Tsvetelin. My problem is different. If I create with sql query all okay. I create foreign key but in foreign keys list doesnt show writes indx.
Hi Rufat !
Thanks for reaching out.
This is a well-known issue in MySQL Workbench where foreign keys might not appear in the list. You can safely proceed with the next lectures — your setup is fine.
Hope this helps.
Best,
Tsvetelin
Thanks for reaching out.
This is a well-known issue in MySQL Workbench where foreign keys might not appear in the list. You can safely proceed with the next lectures — your setup is fine.
Hope this helps.
Best,
Tsvetelin