mysql auto_increment warning

[gwartheg]

Hi,

I'm just starting out with MySQL, and I'm trying the following script to load a simple, tab-delimited table into my database:

DROP TABLE IF EXISTS SEQ;

CREATE TABLE SEQ (
       SEQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
	SEQ VARCHAR (255),
	 CLINICAL VARCHAR (80),
	  CLASS VARCHAR (2),
	   GLOCUS VARCHAR (10),
	    INDEX DISEASE (CLINICAL(10),CLASS),
	     PRIMARY KEY (SEQ_ID)
);

LOAD DATA LOCAL INFILE "~/AMYLOID/autoseq.tmp" INTO TABLE SEQ
     (SEQ, CLINICAL, CLASS, GLOCUS);

It loads the data as expected, but generates a single warning:

mysql> source setupSEQ.sql;
Query OK, 442 rows affected (0.12 sec)
Records: 442  Deleted: 0  Skipped: 0  Warnings: 1

It's only a warning, and as such, the mysql logs are no help, but it just nags me. If I can ignore this warning, I'd like to understand why. Thanks.

[gwartheg]

Whoops - I should learn to read my book more closely. I only specified a length of 2 for my CLASS field; varchars need an extra byte to store the length. Nevermind.