Creating tables
Create table linnad(
linnID intAuto_increment PRIMARYKEY,
linnanimi varchar(15),
rahvaarv int);
Create table logi(
id intAuto_increment PRIMARYKEY,
aeg DATETIME,
toiming varchar(100),
andmed varchar(200)
)
Creating an add trigger
Adding data and checking the trigger
Creating a deletion trigger
trigger check
Creating an update trigger
Functional check
Creating two new tables
Createtablelogitabel(
id intAuto_increment PRIMARYKEY,
aeg DATETIME,toiming varchar(100),
AUTOandmed varchar(200)
);
CreatetableAuto(
AutoID intAuto_increment PRIMARYKEY,
autonumber varchar(6),
mark varchar(20),
mudel varchar(20),
omanik varchar(50)
);
Trigger for deletion
Creation trigger
Trigger for update
Displaying logs
