|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
creation of primary key
hello
I just started using MySQLcontrol center (or MYSQLCC) and I want to create a table using the gui with Primary Key articlenr and 3 other atributes how can I make my articlenr the primary key(PK)? If i create the articlenr row and set PK to it by putting it in the Fields Used for Primary key I can not choose what kind of PK it has to be (I think I need the Unique) ---edit--- I did found an answer between difference of index and unique now I still need to know what is a full text PK --- end edit---- 2nd question what is the difference between index type index unique full text thank you anatak ps: this is no homework (way too old to do homework) |
|
#2
|
||||
|
||||
|
index = a column in a table that the RDBMS "index"'s (catalogue's) to make searching faster... like when you do a "WHERE pkid = 5"... the pkid field would be indexed...
unique = self explanatory full text = someone correct me if i'm way off, but this is were the RDBMS index's a text field, allowing you to query text fields quickly... like how google works. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > creation of primary key |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|