~drizzle-trunk/drizzle/development

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/basic_update.data";
INSERT INTO t1 VALUES (222, "bbb");
INSERT INTO t1 VALUES (333, "ccc");
INSERT INTO t1 VALUES (444, "ddd");
UPDATE t1 SET a=999 WHERE a=444;
UPDATE t1 SET b="zzz" WHERE a=222;
SELECT * FROM t1;
a	b
222	zzz
999	ddd
111	aaa
333	ccc
DELETE FROM t1 WHERE a!=111;
DROP TABLE t1;