how are you migrating your db? mysql used to have a migration toolkit as part of mysql gui tools bundle which handled access->mysql migration very well. the gui tools have now been replaced by mysql workbench, but you can still download them from mysql website. gui tools: http://dev.mysql.com/downloads/gui-tools/5.0.html workbench: http://dev.mysql.com/downloads/workbench/5.2.html
mysql equivalent of access's autonumber type is an Integer column with auto_increment attribute. http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html (bottom of page for auto_increment attr info) you can also set/change the next auto_increment value to use on mysql column: ALTER TABLE t2 AUTO_INCREMENT = value (from http://dev.mysql.com/doc/refman/5.5/en/alter-table.html) all this and much much more is covered in mysql reference manual on mysql website: http://dev.mysql.com/doc/ another point to keep in mind: if you cfqueries used any access-specific syntax you will have to re-write them to use proper sql to work with mysql db. Azadi On 20/04/2011 13:46 , Scott Williams wrote: > Oy -- I shouldn't have started this one until the weekend. > > I'm converting from MS Access to MySQL on one of my ColdFusion sites, and > having problems converting my Autonumbered Access tables to MySQL format. > They just won't import at all. If I remove the primary key and change the > format to Integer instead of Autonumber, the tables import. > > The real problem is when I try to add data to these tables later. It will > take one additional record (numbering it 0), then won't take anymore because > then there would be two 0s. > > How can I get a MySQL table to autonumber like Access? > > Scott > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
