To better understand my question what Add key means in this situation:
ALTER TABLE productvariants ADD PRIMARY KEY (variantId), ADD KEY (buyPrice), ADD KEY (productCode);
Asked
Active
Viewed 102 times
1
-
well... it means please mysql ADD a KEY on that column... – Laurent S. Jan 22 '15 at 13:29
-
Indeed, but by that KEY means add an index on those 2 columns? – mugurelf Jan 22 '15 at 13:33
-
Seriously man, there are plenty of ressources out there, your wasting your time and ours asking such questions here... – Laurent S. Jan 22 '15 at 13:41
-
I didn't meant to waste anyone's time, i just wanted a direct answer because i thought here is the right place to get. – mugurelf Jan 22 '15 at 13:49
-
But if that's the case i will search on the web some more. – mugurelf Jan 22 '15 at 13:50
-
It seems you didn't put a lot of time searching : http://stackoverflow.com/questions/924265/what-does-the-key-keyword-mean – Laurent S. Jan 22 '15 at 13:51