Re: Strange problem when loading a table -- What did I do wrong?

[Brian Gray]

>>you use varchar for an ID?! why not INT?

I wasn't going to be used for any calculations so I didn't bother and it had leading zeros.

065926040+Amini+Daud+damini
039881032+Anjum+Umar+uanjum
061456042+Baker+James Christopher+jcbaker
016338048+Bouttchenko+Kirill+kbouttch
052166048+Capiral+Nino Angelo ramos+nacapira
016870016+Chan+Henry Ka Ho+hkchan4
027324045+Dennis+Rayon+rdennis1
050446004+Dhama+Andrew Justin+ajdhama

These are some rows from my infile
don't have my create table statement anymore.

But something like this

mysql> create table students1
-> (STUDID varchar(9) primary key,
-> LNAME varchar(30),
-> FNAME varchar(30),
-> LEARNID varchar(15) NULL);


Thanks
Brian