Home > database >  With navicat in mysql import excel, bit format how to import? No matter what fill after import in th
With navicat in mysql import excel, bit format how to import? No matter what fill after import in th

Time:09-16

Mysql data in the table is established using springboot, Boolean types of fields in mysql stored as bit type, with navicat in mysql import data in excel, bit types of content, regardless of what excel spreadsheet is imported into the mysql is 1, after I tried to enter false, enter 0, content of form is not set and mysql to the field to set the default value is 0, change the text frame format for "text", which doesn't work, ask for help

CodePudding user response:

The building Lord I just have this problem, and finally solved content is set to the empty string,
  • Related