Does WHERE have to point to PRIMARY KEY?

Codes here !

Moderators: egami, macek, gesf

Post Reply
Tony121076
New php-forum User
New php-forum User
Posts: 28
Joined: Fri Jan 03, 2003 4:00 pm

Fri Jan 31, 2003 3:14 am

when doing an "UPDATE" or "DELETE" mySQL call, does the WHERE need to refer to the PRIMARY KEY, or can it refer to and columb name?

User avatar
Redcircle
Moderator
Moderator
Posts: 826
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Fri Jan 31, 2003 12:21 pm

NO.. it is just recommended because it is faster.

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 3 guests