Jump to content

Archived

This topic is now archived and is closed to further replies.

googsnet

Newbie --> Does anyone know what kind of key the bold code below creates?

Recommended Posts


I need to know what kind of Key is generated by this PHP code (line 9)

1. <?PHP
2.
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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.