Just converts a CSV file into the db, CSV some lines are missing, is characterized by that in the CSV, nothing between two commas, want to change a NULL value to a default value, but I found that I use the update table set col1=NULL where col1=""; Don't have any happens, select can grab the free value, excuse me somebody know

CodePudding user response:

Estimate is in itself a NULL value, you can use the case when xx is NULL then 1 else 0 end check, return 1 if the corresponding record, that is NULL
If it returns 0 with hex (CXX) and see what's inside

CodePudding user response:

reference no. 1 floor ZJCXC -- personal WeChat public same response:

estimate itself is a NULL value, you can use the case when xx is NULL then 1 else 0 end check, return 1 if the corresponding record, that is NULL
If it returns 0 with hex (CXX) and see what's inside the

yesterday, I tried a null or "" if all have no, I try again, thank you