Re: "you should define a primary key for this table" - why?
Available news archives: comp.lang.tcl - comp.lang.python - comp.security.firewalls - sci.crypt - comp.lang.php - comp.lang.javascript
Google
 
Web news.hping.org


comp.lang.php archive

Re: "you should define a primary key for this table" - why?

From: CAH <madsgormlarsen@gmail.com>
Date: Sat Sep 24 2005 - 11:06:59 CEST

> I don't use phpmyadmin, but I assume that it would like to use the
> primary key to make sensible select/update-statements. Apart from
> that, it is just an advice for your own good.
>
> Primary keys are to ensure integrity, but you get performance gains as
> an added bonus, because you get the table indexed. In other words,
> without a primary key (when applicable), you risk making a mess of
> your data and having a crappy performance. But the choice is still up
> to you. :)

Thanks for the tip, I will try to make one.

I see what you mean, I will try to make the kind of joint ket mensionen
above.

Cah
Received on Tue Oct 18 02:27:32 2005