is it possible to do something like
CREATE TABLE tmp_x (acctcode CHAR(25));
LOAD DATA
INFILE ‘ComboCodeTab2Dec2015.csv’
INTO TABLE tmp_x
…
nad then use that “temp table” to update values in a DB ?
thanks
Kathryn
is it possible to do something like
CREATE TABLE tmp_x (acctcode CHAR(25));
LOAD DATA
INFILE ‘ComboCodeTab2Dec2015.csv’
INTO TABLE tmp_x
…
nad then use that “temp table” to update values in a DB ?
thanks
Kathryn
To import from CSV (and other formats), look at Database -> Import -> Import Table data.