Unable to import all values from google sheets to sql

I'm trying to import data from google sheets to mysql. I saved the google sheet as .csv. One of the columns square_feet has very few entries so there are a lot of blank cells. I am unable to import any row which has those blank cells. The error I'm getting is.

INSERT INTO airbnb VALUES ('2265', 'Austin', 'TX', '78702', 'Austin', 'United States', 'House', 'Entire home/apt', '4', '', '$225.00', '$100.00')

#1366 - Incorrect integer value: '' for column 'square_feet' at row 1

The column square_feet when created was given data type int not null, no default value assigned.

https://stackoverflow.com/questions/65571910/unable-to-import-all-values-from-google-sheets-to-sql January 05, 2021 at 09:07AM