Jump to content


Photo

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


  • Please log in to reply
1 reply to this topic

#1 googsnet

googsnet
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 11 September 2006 - 09:39 PM


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. KEY(sess))";
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

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 11 September 2006 - 09:55 PM

The manual:

KEY is normally a synonym for INDEX.


This should be helpful.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users