CREATE TABLE t1 (
  int x default 100,
  int y
);

INSERT INTO t1 (y) VALUES (1);

SELECT * FROM t1;