mysqlimport failed to import

[Scott Hamm]

I created a csv file entitled 'disposed.csv' and placed it in 
computer_inventory data folder with the following inside:

1087
1046
1086
1161
1049
1178
1029
1030
1224
1044
1106

Now I created the table 'disposed' as following:

Create disposed (
Mot_id INT(4) UNIQUE NOT NULL
);

Then I issued the command inside computer_inventory data folder as follows:

Mysqlimport -u root -p computer_inventory disposed.csv

And got the error:

Mysqlimport: Error: Data truncated for column 'mot_id' at row 1, when using 
table: disposed


What am I doing wrong?


[cid:image001.jpg@01C91A66.5935E360]

<<inline: image001.jpg>>

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