2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
DROP TABLE IF EXISTS test.t1;
8
CREATE TABLE test.t1 (a VARCHAR(255), PRIMARY KEY(a));
9
LOAD DATA INFILE '../std_data_ln/words2.dat' INTO TABLE test.t1;
10
DELETE FROM test.t1 WHERE a = 'abashed';
12
LOAD DATA INFILE '../std_data_ln/words2.dat' INTO TABLE test.t1;
13
SELECT * FROM test.t1 ORDER BY a DESC;
65
SELECT * FROM test.t1 ORDER BY a DESC;