INF4211

Bases de données pour les organisations

Project maintained by guyfrancoeur Hosted on GitHub Pages — Theme by mattgraham

Les contraintes, défaut

--CREATE
CREATE TABLE abc (
  colA varchar(10) null, 
  colB numeric null, 
  colC date null
);

CREATE TABLE gh (
  colA varchar(10) not null default 'AA', 
  colB numeric not null default 2,
  colC date not null
);

--INSERT
INSERT INTO gh (ColC) values ('2000-01-01');

INSERT INTO gh (ColB) values (3);

INSERT INTO gh (ColB,ColC) values (3, '2021-01-01');

SELECT * FROM gh;