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): Unknown column ‘Target’ in ‘field list’. So I entered INSERT INTO merchants (AXPID, Vendor, Storenum)… Read More MySQL inconsistently requires quote marks around varchar inputs