Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table bestand.lieferung
- (liefernr int(11) not null primary key auto_increment,
- hersteller varchar(40) not null,
- modell varchar(40) not null,
- typ enum("Monitor", "Computer", "Drucker") not null,
- lieferdatum date not null,
- rechnungsdatum date not null,
- stueckzahl int(5) not null);
- explain bestand.lieferung
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement