MySQL inconsistently requires quote marks around varchar inputs
In my "merchants" table, column AXPID is of integer data type, Vendor is varchar(255) and StoreNum is varchar(20). at the mysql command line, I entered INSERT INTO merchants (AXPID, Vendor, Storenum) VALUES (3, Target, 1911); and got "ERROR 1054 (42S22):…