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 / insert_select.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  478 b   |  13 lines  |  [TEXT/ttxt]
  1. #
  2. # Problem with INSERT ... SELECT
  3. #
  4.  
  5. drop table if exists t1,t2;
  6. create table t1 (bandID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, payoutID SMALLINT UNSIGNED NOT NULL);
  7. insert into t1 (bandID,payoutID) VALUES (1,6),(2,6),(3,4),(4,9),(5,10),(6,1),(7,12),(8,12);
  8. create table t2 (payoutID SMALLINT UNSIGNED NOT NULL PRIMARY KEY);
  9. insert into t2 (payoutID) SELECT DISTINCT payoutID FROM t1;
  10. insert into t2 (payoutID) SELECT payoutID+10 FROM t1;
  11. select * from t2;
  12. drop table t1,t2;
  13.