MySQL > sdqd

CREATE TABLE vins(
nvin NUMBER(3) NOT NULL,
nomcru VARCHAR2(25),
annee NUMBER(4) NOT NULL,
degres NUMBER(5,3),
prix NUMBER(4,2),
CONSTRAINT pk_vins PRIMARY KEY(nvin)
);