I’m in the process of importing a bunch of data from an Excel file into a MySQL database using the Navicat import wizard, and I’m having some trouble… A few of the columns are just a true/false type (I’m just using TINYINT with 1s or 0s to handle that in MySQL), but not every field has a true or false yet, so I’m trying to just populate those ones with NULL - those ones are just empty cells in Excel. But when I import it in, all of the empty cells just change to 0. I’ve made sure that NULL is allowed, and is the default for those fields in MySQL, but it still just changes them to 0s.
Any ideas? Thanks