--------------080606040003090105080201
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I have the same table defined in multiple catalogs. The table contains
a primary key that is set to auto-increment. In some of the tables,
auto-increment works fine. In certain others, the table column that
should be auto-incrementing returns a 0 value. Can anyone help? The
tables are ISAM.

The table definition is: "CREATE TABLE version (refNo BIGINT NOT NULL
AUTO_INCREMENT, revYear INT NOT NULL, sequence INT NOT NULL, revDate
DATETIME, PRIMARY KEY (refNo), INDEX dateIdx(revDate), INDEX serNoIdx
(sequence)) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci

Thanks
Gary


--------------080606040003090105080201
Content-Type: text/plain; charset=us-ascii


--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw
--------------080606040003090105080201--

Gary Anderson wrote:
I would try inserting a row using the mysql command line utility. Based
on your report, I would expect that to also misbehave, which makes this
a MySQL problem, not a MySQL++ problem. If you can confine it to
MySQL++, that would be very interesting indeed.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw