database assignment

Posted by eric on Stack Overflow See other posts from Stack Overflow or by eric
Published on 2010-04-26T13:47:05Z Indexed on 2010/04/26 13:53 UTC
Read the original article Hit count: 186

CREATE TABLE T1 (A INTEGER NOT NULL);
CREATE TABLE T3 (A SMALLINT NOT NULL);
INSERT T1 VALUES (32768.5);
SELECT * FROM T1;
INSERT T3 SELECT * FROM T1;
SELECT * FROM T3;

© Stack Overflow or respective owner