![]() If you are using new phpmyadmin then use new “Relation view” tab to make foreign key relation You should now see the Relation view link.įirst ensure that your table storage engine type should be innoDB (you can set it using Table operations Tab) Go to your database and view one of your tables in Structure mode. Save the file and restart MAMP and refresh your phpMyAdmin console. If you left everything default in the create_tables.sql file then you should just cut and paste the lines below. Open /Applications/MAMP/bin/phpMyAdmin/įind the Server(s) configuration code block and replace/uncomment the following code and fill in the values.The tables required for Relation view will be added to the database you specified. ![]() Click the browse button and find the create_tables.sql file and then click Go.Open phpMyAdmin and go to the Import tab.I left this file default but you can change the table name to anything.Find /Applications/MAMP/bin/phpMyAdmin/scripts/create_tables.sql.If you can’t you’ll need to follow the steps below to set phpMyAdmin to enable Relations view. Depending on your version of phpMyAdmin you should see a link titled Relation view below the table structure. Now, go back to your table view and click the Structure tab. ![]() Make sure that the storage engine is set to use InnoDB and save your changes. Click on a table within your database and choose the Operations tab. You need to make sure your tables’ storage engine is set to use InnoDB. To do this open phpMyAdmin and select a database. If you’re creating a database you might be wondering how to create relationships and foriegn keys for your tables.įirstly you need to check that you have access to the Relation view. If you’re using MAMP for your database driven projects you’ll probably be using phpMyAdmin to administer your MySQL database if you’ve decided to go down that route. InnoDB will allow you to view the “relation view” which will help you make the foreign keyĮnabling Relation View in phpMyAdmin / MAMP If it’s too late at night and your table is already innoDB and you still don’t see the link, maybe is due to the fact that now it’s placed above the structure of the table, like in the picture is shown Method 3įirst select the table you you would like to make the relation with > then go to operation, for each table there is difference operation setting, > inside operation “storage engine” choose innoDB option If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.Ĭhange your storage engine to InnoDB by going to Operation Method 2 Please note that all the answers may not help you solve the issue immediately. If something is not working, please don’t hesitate to comment it below.Thank you for visiting the Q&A section on Magenaut. You’ve learned how to enable designer tab in phpmyadmin. This is the database that I’m using for keeping track of my dvd and cd collection on all kinds of stuff that interests me. Hopefully you can now see the designer tab whenever you try to open up a database in phpmyadmin.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |