I think the real question is: What´s the purpose of any other field in my primary key if the first one is an auto_increment and will never repeat?
-- João Cândido de Souza Neto "Victor Subervi" <victorsube...@gmail.com> escreveu na mensagem news:aanlktinyaaps4jmbbjald6kdok7lfhxlykwq0tmpt...@mail.gmail.com... 2010/6/29 João Cândido de Souza Neto <j...@consultorweb.cnt.br> > As far as I know, if you have an auto_increment primary key, you cant have > any other field in its primary key. > Makes sense. Actually, I was just copying what someone else gave me and adding the auto_increment, then I got to wondering, what is the purpose of having two primary keys? TIA, V -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
