Category

Development Platform
Home > SourceCode/Document > Database system > MySQL > View Code
sel000001.test
Package: mysql-3.23.35.tar.gz　[view]
Upload User: tsgydb
Upload Date: 2007-04-14
Package Size: 10674k
Code Size: 0k
Category:

MySQL

Development Platform:

Visual C++

sel000001.test：Code Content
  1. # sel000001
  2. #
  3. # Versions
  4. # --------
  5. #   3.22
  6. #   3.23
  7. #
  8. # Description
  9. # -----------
  10. # This test is just a simple select.
  11. # Testing WHERE clause.
  12. #
  14. DROP TABLE IF EXISTS t1;
  15. CREATE TABLE t1 (s CHAR(20) PRIMARY KEY, id INT);
  16. INSERT INTO t1 VALUES ('cat', 1), ('mouse', 3), ('dog', 2), ('snake', 77);
  17. @r/sel000001.result SELECT s, id FROM t1 WHERE s = 'mouse';
  18. drop table t1;