Code Forums - View Single Post

gwartheg · 06-11-2003, 07:55 AM

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:

Code:

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:

Code:

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.

06-11-2003, 07:55 AM	#1 (permalink)
gwartheg Registered User Join Date: Aug 2002 Location: Boston, MA Posts: 8	mysql auto_increment warning 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: Code: 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: Code: 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.