CREATE a foreign key
From SQLZOO
Revision as of 14:08, 28 November 2012 by 91.176.206.53 (Talk)
CREATE TABLE microprocessors
(jaar INTEGER PRIMARY KEY ,architectuur VARCHAR(15) ,fabricant VARCHAR(10) ,aantalcores INTEGER ,aantalthreads INTEGER
);
INSERT INTO microprocessors(jaar, architectuur, fabricant, aantalcores, aantalthreads) VALUES (2011,Sandy Bridge,intel,4,8);
SELECT * FROM microprocessors;