1. load data
LOAD DATA INFILE 'filename into table tablename FIELDS TERMINATED BY '\t' (column1,column2,@dummy,@var1,@var2) SET visitIp = INET_ATON(@var1), isFocus = IF(@var2=1,b'1',b'0');
请注意 @dummy, @var1, @var2; @dummy 的作用相当于将filename data中的某个字段过滤掉,不保存到 新的table中, 而 @var, 则相当于一个占位符,使得filename data中当前的zhi 存到@var1中, 并在 set语句中 对新 table中的字段重新赋值。
2. select into out file:
select * into outfile 'filename' from tableName;
select * into outfile 'filename' from tableName where column = 696;