SQL laused

Tabeli loomine:

CREATE TABLE toode(
ToodeId INT PRIMARY KEY AUTO_INCREMENT,
ToodeNimetus VARCHAR(256),
ToodeHind DECIMAL(5,2)
V_kuupeav DATE, 
kas_olema BIT
);

lisa teavet:

INSERT INTO toode(ToodeNimetus, ToodeHind, V_kuupeav, kas_olema)
VALUES ("banad",14.12,"2024-01-31",0);

SELECT * from toode;


CREATE TABLE `aleksanderkaasikbass`.`telimus` (`Telimus` INT NOT NULL AUTO_INCREMENT , `TelimusPeav` DATE NOT NULL , `ToodeId` INT NOT NULL , `klient` VARCHAR(50) NOT NULL , PRIMARY KEY (`Telimus`)) ENGINE = InnoDB;

Uue veeru lisamine:

alter table telimus add FOREIGN KEY (ToodeId) REFERENCES toode(ToodeId);

Piirangid:

  • primary key,
  • foreign key,
  • not null
  • unique

Lisa:

INSERT INTO product(ProductName, idCategory, Price)
VALUE
  ("test0",1,"1.01"),
  ("test1",2,"2.22"),
  ("test3",3,"3.33");