~xnox/ubuntu/saucy/drizzle/merge

« back to all changes in this revision

Viewing changes to .pc/debian-changes-2010.12.06-0ubuntu4/plugin/filesystem_engine/tests/r/basic_update.result

• browse files at revision 11
• compare with another revision
• download diff
• download tarball
• view history from revision 11

Show diffs side-by-side

added

removed

.pc/debian-changes-2010.12.06-0ubuntu4/plugin/filesystem_engine/tests/r/basic_update.result

 

1

DROP TABLE IF EXISTS t1;

 

2

CREATE TABLE t1 (a INT, b VARCHAR(20)) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/basic_update.data";

 

3

INSERT INTO t1 VALUES (222, "bbb");

 

4

INSERT INTO t1 VALUES (333, "ccc");

 

5

INSERT INTO t1 VALUES (444, "ddd");

 

6

UPDATE t1 SET a=999 WHERE a=444;

 

7

UPDATE t1 SET b="zzz" WHERE a=222;

 

8

SELECT * FROM t1;

 

9

a       b

 

10

222     zzz

 

11

999     ddd

 

12

111     aaa

 

13

333     ccc

 

14

DELETE FROM t1 WHERE a!=111;

 

15

DROP TABLE t1;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1