googsnet Posted September 11, 2006 Share Posted September 11, 2006 I need to know what kind of Key is generated by this PHP code (line 9) 1. <?PHP2. 3. $query = "CREATE TABLE carttemp(4. hidden INT(10) NOT NULL AUTO_INCREMENT,5. sess CHAR(50) NOT NULL,6. prodnum CHAR(5) NOT NULL,7. quan INT(3) NOT NULL,8. PRIMARY KEY (hidden),9. [b]KEY(sess))";[/b]10.11. ?>And is there a way to accomplish this through the phpmyadmin console that my hosting providers are forcing me to use?Thanks in advance.Googsnet Link to comment https://forums.phpfreaks.com/topic/20433-newbie-does-anyone-know-what-kind-of-key-the-bold-code-below-creates/ Share on other sites More sharing options...
effigy Posted September 11, 2006 Share Posted September 11, 2006 The manual:[quote]KEY is normally a synonym for INDEX.[/quote][url=http://dev.mysql.com/doc/refman/5.0/en/create-index.html]This[/url] should be helpful. Link to comment https://forums.phpfreaks.com/topic/20433-newbie-does-anyone-know-what-kind-of-key-the-bold-code-below-creates/#findComment-90036 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.