|
1548.4.66
by Zimin
add basic delete for filesystem storage engine |
1 |
--disable_warnings
|
2 |
DROP TABLE IF EXISTS t1; |
|
3 |
--enable_warnings
|
|
4 |
||
|
1786.3.2
by Monty Taylor
Cleaned up the initial pass at this. It's not perfect, but it does work. |
5 |
CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/basic_delete.data"; |
|
1548.4.66
by Zimin
add basic delete for filesystem storage engine |
6 |
|
7 |
INSERT INTO t1 VALUES (222, "bbb"); |
|
8 |
INSERT INTO t1 VALUES (333, "ccc"); |
|
9 |
INSERT INTO t1 VALUES (444, "ddd"); |
|
10 |
INSERT INTO t1 VALUES (555, "eee"); |
|
11 |
INSERT INTO t1 VALUES (666, "fff"); |
|
12 |
||
13 |
SELECT * FROM t1; |
|
14 |
||
15 |
DELETE FROM t1 WHERE a>=444; |
|
16 |
DELETE FROM t1 WHERE b="bbb"; |
|
17 |
DELETE FROM t1 WHERE a!=111; |
|
18 |
||
19 |
SELECT * FROM t1; |
|
20 |
||
21 |
DROP TABLE t1; |