home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / key_primary.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  377 b   |  15 lines  |  [TEXT/ttxt]
  1. #
  2. # test of primary key conversions
  3. #
  4.  
  5. create table t1 (t1 char(3) primary key);
  6. insert into t1 values("ABC");
  7. insert into t1 values("ABA");
  8. insert into t1 values("AB%");
  9. select * from t1 where t1="ABC";
  10. select * from t1 where t1="ABCD";
  11. select * from t1 where t1 like "a_\%";
  12. describe select * from t1 where t1="ABC";
  13. describe select * from t1 where t1="ABCD";
  14. drop table t1;
  15.