[SOLVED] Does every database need a primary key?

[HowdeeDoodee]

I have several full text indexed databases and some not full text. Does every database need a Primary key?

 

Here is how a typical full text db is set up.

 

Source INDEX 3

Lnum    INDEX

Topic FULLTEXT

Subtopic  FULLTEXT

Theswords  FULLTEXT

 

Here is how a typical non-full text db is set up.

 

Source INDEX 3

Lnum    INDEX

Topic INDEX

Subtopic  INDEX

Theswords  INDEX

 

What is the purpose of primary key? Does adding a primary key enable the db to be searched more rapidly?

 

[fenway]

What does PK have to do will fulltext?  And yes, for joins and most other things, PKs are essential... only in InnoDB under rare circumstances in an surrogate PK a bad idea.

[HowdeeDoodee]

Thank you for the comment. What does the primary key do and does a primary key enable a db to be searched more rapidly?

[bubblegum.anarchy]

A primary key identifies a record and indexing increases search times; primary keys are indexed.

[Illusion]

and also you can not enter duplicate values in a primary key column.

[HowdeeDoodee]

Thank you bubblegum and illusion.