On Friday 13 December 2002 20:43, you wrote:
Hi Sean,
this is not a bug:
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
For MyISAM and BDB tables you can specify AUTO_INCREMENT on secondary column
in a multi-column key. In this case the generated value for the autoincrement
column i
Hi all, I have recently encountered some strange (to me) behaviour with an
auto
increment column. It resulted because of an oversight in table creation.
Here is some SQL statements that will illustrate my issue:
CREATE TABLE test (
ID INT AUTO_INCREMENT,
Name CHAR(30),
KEY (Name, ID)
)