SQL INSERT examples

INSERT INTO Gene(number, name, species, chromosome)
     VALUES (25, 'K-ras', 'Homo sapiens', '8');

INSERT INTO Gene(number, name, species) VALUES (26, 'H-ras', 'Homo sapiens');

Gene
number INT PRIMARY KEY	name VARCHAR NOT NULL	species VARCHAR NOT NULL	chromosome VARCHAR	first INT	last INT
...
25	'K-ras'	'Homo sapiens'	'8'	NULL	NULL
26	'H-ras'	'Homo sapiens'	NULL	NULL	NULL

CREATE TABLE Species (
  number INT PRIMARY KEY,
  name   VARCHAR(100) NOT NULL
);

INSERT INTO Species(number, name) VALUES(1, 'Homo sapiens');

Species
number INT PRIMARY KEY	name VARCHAR NOT NULL
1	'Homo sapiens'