Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to load a very normal .csv file (that was created from Excel 2011 for Mac) into SequelPro (using MySQL) with my Mac -- and I've recently started getting this error consistently. Can anybody let me know what it is and how to fix it?

An error occurred while trying to add the new table 'wblist' by

CREATE TABLE `wblist` (
`FILE` VARCHAR(255), 
`FIRSTNAME` VARCHAR(255), 
`MIDDLE` VARCHAR(255), 
`LASTNAME` VARCHAR(255), 
`FULLNAME` VARCHAR(255), 
`GENDER` VARCHAR(255), 
`ADDRESS` VARCHAR(255), 
`CITY` VARCHAR(255), 
`STATE` VARCHAR(255), 
`ZIP` VARCHAR(255), 
`PHONE` BIGINT(11), 
`UNIT` VARCHAR(255), 
`JOB` VARCHAR(255), 
`AREA` VARCHAR(255), 
`TIME` VARCHAR(255), 
`MAILINGADDRESS` VARCHAR(255), 
`MAILINGCITY` VARCHAR(255), 
`MAILINGSTATE` VARCHAR(255), 
`MAILINGZIP` VARCHAR(255), 
`ID` BIGINT(11), 
`CONFIDENCE` VARCHAR(255), 
`BIRTHDATE` VARCHAR(255), 
`AGE` INT(11), 
`RACE` VARCHAR(255), 
`ETHNICITY` VARCHAR(255), 
`RELIGION` VARCHAR(255), 
`PARTY` VARCHAR(255), 
`REGISTRATIONDATE` VARCHAR(255), 
`VOTERSTATUS` VARCHAR(255), 
`OtherPhone` VARCHAR(255), 
`POSSIBLEADDRESS` VARCHAR(255), 
`POSSIBLEMAILADDRESS` VARCHAR(255), 
`RECID` VARCHAR(255)) ENGINE=CSV;

MySQL said: The storage engine for the table doesn't support nullable columns

This is stopping me before I'm able to import the table. Thanks for the help!

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.