| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|MySQL: Primar y key, index, unique|
what is what?
| 11:52 am on Mar 19, 2008 (gmt 0)|
In MySQL - what is a "primary keys"?
Is it one column in a table?
Can it be more than one column?
Is it the same as an Index?
Does a table HAVE to have a primary key?
| 9:04 am on Mar 24, 2008 (gmt 0)|
|Is it one column in a table? |
It can be one or more.
|Is it the same as an Index? |
No, a primary key uniquely identifies each individual row in a table. An index improves the speed of operations on a table, it can also be on one or more columns.
|Does a table HAVE to have a primary key? |
No, but it is good practice IMHO.
| 9:20 am on Mar 24, 2008 (gmt 0)|
Thanks for posting, bad one - and thanks for your straight answers. Kudos.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved