joshbb Posted June 18, 2010 Share Posted June 18, 2010 Can any body help me how I create relationships i.e. normalize my tables using phpmyadmin. Link to comment https://forums.phpfreaks.com/topic/205144-mysql-relationship-between-table/ Share on other sites More sharing options...
Mchl Posted June 18, 2010 Share Posted June 18, 2010 No one will do it for you, but if you ask specific questions there's a fair chance people will answer. Link to comment https://forums.phpfreaks.com/topic/205144-mysql-relationship-between-table/#findComment-1073787 Share on other sites More sharing options...
joshbb Posted June 18, 2010 Author Share Posted June 18, 2010 I mean as we create tables in SQL then we create relationship between tables by using primary and foreign key. How we will do that in phpmyadmin. Link to comment https://forums.phpfreaks.com/topic/205144-mysql-relationship-between-table/#findComment-1074054 Share on other sites More sharing options...
Mchl Posted June 18, 2010 Share Posted June 18, 2010 1. Tables must be InnoDB (or XtraDB or other engine that supports FK constraints) 2. In PMA select a table, where you want to add a FK constraint, go to 'Structure' tab 3. make sure there is an index created on FK column 4. click 'Relation view' (at the bottom) 5. From the dropdown list next to FK column name, select a table and column that the constraint is to belong to 6. Select ON DELETE and ON UPDATE actions 7. Click 'Save' Link to comment https://forums.phpfreaks.com/topic/205144-mysql-relationship-between-table/#findComment-1074061 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.