BullZip Home

I found the solution myself. I need to add a line into the table definition after the AUTO_INCREMENT column: primary key (column name), Maybe the developers of 'Access to Mysql' should add this fix to the program. Access to Mysql is great software, by the way. Simple to use and does exactly what one...

I try to convert an MS access (2000) database to mysql 5.2 This table definition gets created in the dump file: CREATE TABLE `tblCategory` ( `CategoryID` INTEGER NOT NULL AUTO_INCREMENT, `DatamainID` INTEGER, `CodeID` INTEGER, `CategoryNotes` VARCHAR(255) ) TYPE=MyISAM; When I run this dump file wit...