# sel000001 # # Versions # -------- # 3.22 # 3.23 # # Description # ----------- # This test is just a simple select. # Testing WHERE clause. # DROP TABLE IF EXISTS t; CREATE TABLE t (s CHAR(20) PRIMARY KEY, id INT); INSERT INTO t VALUES ('cat', 1), ('mouse', 3), ('dog', 2), ('snake', 77); @r/sel000001.result SELECT s, id FROM t WHERE s = 'mouse';