I have this
CREATE TABLE `dictionary` ( `id` int(11) NOT NULL auto_increment, `word` text NOT NULL, `def` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; I have a huge text file, that is in the format of string<tab>string<return> I want to load this into mysql, but I want to skip the id field and let that auto populate with the auto increment value. What is the syntax for this? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
