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 Quote Link to comment 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. Quote Link to comment 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.