fields terminated by ',' optionally by '"'
(col1 char(5),col2 char(7))

ex.dat file

009hello,cd,
010world,im,
012my,name is,
col1 is char(5) where as in the ex.dat it is more than 5. correct that.

Thanks,