Re: load data

[tlr7425]

If the ID field is *not in your text file, why not take it out of the 
CREATE statement and add it afterwards?

Ted

On Thursday, June 26, 2003, at 10:46  PM, Scott Haneda wrote:

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?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]