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. Quote 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. Quote 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. Quote 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' Quote Link to comment https://forums.phpfreaks.com/topic/205144-mysql-relationship-between-table/#findComment-1074061 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.