I've recently converted a CRM database with about 20k entries. I exported the data to ACCESS had to tweak the field names and value then Inserted all into mySQL with mySQL Administrator. During the conversion out of the CRM into ACCESS the unique Primary Key for each contact, which is also the Foreign Key joining the other tables was changed to an integer with 27 digits. Then during the transfer from ACCESS to mySQL this Primary Key was inserted into a VARCHAR field. I would like to change the field type to INT so I can add auto_increment however the number is too large for even BIGINT. IT is possible to update all of these unique primary keys with a lower value AND have it populate the 12 other tables with the correct NEW value or each entry in the joined tables? Not sure if I have to back track and do this in the Access step (which I know very little about) or if there is a way to easily do this with mySQL.
Thanks for any insight. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]