I'm using InnoDB tables and created a new one with an autoincrement field to use for a primary key. These tables are being loaded from text files that I create out of another database system (Lotus Notes). My question is what must I do in the text file structure to account for the autoincrement field? Do I include a first field with \N? If the MySQL table has 20 columns with the first being the autoincrement, can my load file be only 19 columns? Thanks. Randy
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]