492
492
#SELECT DISTINCT fruit_id, fruit_name INTO OUTFILE
493
493
#'../tmp/data1.tmp' FROM t1 WHERE fruit_name = 'APPLE';
494
494
#LOAD DATA INFILE '../tmp/data1.tmp' INTO TABLE t2;
497
497
#SELECT DISTINCT @v19:= fruit_id, @v20:= fruit_name INTO OUTFILE
498
498
#'../tmp/data2.tmp' FROM t1 WHERE fruit_name = 'APPLE';
499
499
#LOAD DATA INFILE '../tmp/data2.tmp' INTO TABLE t2;