int2_tbl.sql 323 B

123456789101112
  1. CREATE TABLE INT2_TBL(f1 int2);
  2. INSERT INTO INT2_TBL(f1) VALUES ('0');
  3. INSERT INTO INT2_TBL(f1) VALUES ('1234');
  4. INSERT INTO INT2_TBL(f1) VALUES ('-1234');
  5. INSERT INTO INT2_TBL(f1) VALUES ('32767');
  6. INSERT INTO INT2_TBL(f1) VALUES ('-32767');
  7. CREATE TABLE int2_tbl(f1 int2);
  8. INSERT INTO int2_tbl
  9. SELECT * FROM INT2_TBL;