diff options
Diffstat (limited to 'mysql-test/r/sel000001.result')
| -rw-r--r-- | mysql-test/r/sel000001.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/sel000001.result b/mysql-test/r/sel000001.result index bee97cc7b53..28f6d3d1d5a 100644 --- a/mysql-test/r/sel000001.result +++ b/mysql-test/r/sel000001.result @@ -1,2 +1,7 @@ +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 (s CHAR(20) PRIMARY KEY, id INT); +INSERT INTO t1 VALUES ('cat', 1), ('mouse', 3), ('dog', 2), ('snake', 77); +SELECT s, id FROM t1 WHERE s = 'mouse'; s id mouse 3 +drop table t1; |