I have table in tables. I came across that some columns I didn’t pass while insert. how mysql accept to insert those record.
enter image description here
those are the column which added zero value to them when I have inserted rows without passing value to them.
I have double checked that those columns not null and does not have defalut value. and I made sure that global sql_mode variable value is defalut which is ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION. The mysql version is 8.0.