CREATE TABLE table1(kid char(2),color varchar(9));
INSERT INTO table1('k1'.'yello');
INSERT INTO table1('k1'.'red');
INSERT INTO table1('k2'.'yello');
INSERT INTO table1('k2'.'blue');
INSERT INTO table1('k3'.'yello');
CREATE TABLE table1(kid char(2),color varchar(9