RE: Autocolumn and pk

2004-02-10 Thread David Perron
://www.mysql.com/doc/en/example-AUTO_INCREMENT.html -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Linus Nikander Sent: Tuesday, February 10, 2004 8:31 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Autocolumn and pk I'm pretty new to mySQL so there might be an eas

Autocolumn and pk

2004-02-10 Thread Linus Nikander
I'm pretty new to mySQL so there might be an easy way of solving this (hopefully) Is there a way to create something akin to an Oracle Sequence in mySQL ? I know of the autonumber feature. The problem is that the table that will be using the key won't actually be using it as a unique pk. The pk w