Does WHERE have to point to PRIMARY KEY?

Codes here !

Moderators: macek, egami, gesf

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

Does WHERE have to point to PRIMARY KEY?

Postby Tony121076 » 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: 830
Joined: Tue Jan 21, 2003 10:42 pm
Location: Michigan USA
Contact:

Postby Redcircle » Fri Jan 31, 2003 12:21 pm

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


Return to “mySQL & php coding”

Who is online

Users browsing this forum: No registered users and 2 guests