SQLite 3.8

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Penguin (
PenguinID INTEGER PRIMARY KEY,
Name VARCHAR(10),
Height FLOAT,
Weight FLOAT)
insert into penguin (name) values ('name1'), ('name2')
select *
from penguin


PenguinID
Name
Height
Weight


1
name1
null
null

2
name2
null
null