lou22 Posted November 11, 2011 Share Posted November 11, 2011 Hi, I wonder if anyone can help me - I'm a newbie and using phpmyadmin to set up the database in Knowledge is Power - what is the phpmyadmin equivalent to mySql 'key' index in code setting up database tables in Chapter 3? There isn't an option for 'key' just 'primary' 'unique' 'index' 'full text' in phpmyadmin. eg, KEY 'category_id' ('category_id') Thanks Link to comment Share on other sites More sharing options...
Jonathon Posted November 11, 2011 Share Posted November 11, 2011 It's just Index, if you are new to MySQL or PHP this probably isn't the book for you as it does require comfort with both technologies though. Link to comment Share on other sites More sharing options...
lou22 Posted November 14, 2011 Author Share Posted November 14, 2011 Thanks for the reply. Yes, I've realised I need to familiarise myself with php and mysql first. Link to comment Share on other sites More sharing options...
Todd.M Posted November 21, 2011 Share Posted November 21, 2011 Hi Lou22, Just for future reference, if you want to get the most out of designing a database (as with any other programming language) I would recommend that you code it by hand. Just means to type in the structure of the DB and/or Table. You can do this by going to phpMyAdmin > select the SQL tab and type the code into the white box. This is the interface for MySQL Database design. Hope this helps you, Todd Link to comment Share on other sites More sharing options...
Recommended Posts