varchar_tbl.sql 315 B

1234567891011
  1. CREATE TABLE VARCHAR_TBL(f1 varchar(4));
  2. INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
  3. INSERT INTO VARCHAR_TBL (f1) VALUES ('ab');
  4. INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd');
  5. INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd');
  6. CREATE TABLE varchar_tbl(f1 varchar(4));
  7. INSERT INTO varchar_tbl
  8. SELECT * from VARCHAR_TBL;