|
CREATE TABLE t1 (data VARCHAR(4), unique(data) using hash) with system versioning;
|
|
INSERT INTO t1 VALUES ('A'),('B');
|
SELECT * INTO OUTFILE 'load.data' from t1;
|
|
select * from t1;
|
LOAD DATA INFILE 'load.data' INTO TABLE t1;
|
select * from t1;
|
DROP TABLE t1;
|
--let $datadir= `select @@datadir`
|
--remove_file $datadir/test/load.data
|
|
CREATE TABLE t1 (data VARCHAR(4), unique(data) using hash) with system versioning;
|
INSERT INTO t1 VALUES ('A'),('B');
|
SELECT * INTO OUTFILE 'load.data' from t1;
|
select * from t1;
|
data
|
A
|
B
|
LOAD DATA INFILE 'load.data' INTO TABLE t1;
|
select * from t1;
|
data
|
A
|
B
|
A
|
B
|
DROP TABLE t1;
|
main.abc [ pass ] 12
|
|
|