I worte a python script to insert data into a mysql data file. Here is an example of on insert statement...
INSERT INTO temptable (preferred_term_code, feature_code, feature_desc, feature_rank, feature_unit_code) VALUES (1229,"01","Material",,1)
The second to the last field is null and defined as an int..
However, I get errors inserting the record. If I switch the data type to VARCHAR(100) then it works fine.
Here is my create statement for the table...
CREATE TABLE temptable (preferred_term_code INT,feature_code VARCHAR(100),feature_desc VARCHAR(100),feature_rank INT,feature_unit_code INT)
What is going on? And how do I insert the record?