{"id":1066,"date":"2024-09-03T09:26:25","date_gmt":"2024-09-03T06:26:25","guid":{"rendered":"https:\/\/vladislavkudr.wordpress.com\/?page_id=1066"},"modified":"2024-09-10T09:07:55","modified_gmt":"2024-09-10T09:07:55","slug":"sql-triggerid","status":"publish","type":"page","link":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/sql-triggerid\/","title":{"rendered":"SQL TRIGGERID"},"content":{"rendered":"\n

Trigger – protsess, mille abil tema sisse kirjutatud tegevused automatselt k\u00e4ivitakse.<\/p>\n\n\n\n

SQL<\/span><\/path><\/path><\/svg><\/span>
CREATE<\/span> <\/span>DATABASE<\/span> <\/span>TRIGGERKudriashevTARpv23<\/span>;<\/span><\/span>\nUSE<\/span> TRIGGERKudriashevTARpv23;<\/span><\/span>\n--loome tabeli<\/span><\/span>\nCREATE<\/span> <\/span>TABLE<\/span> <\/span>toode<\/span>(<\/span><\/span>\ntoodeId <\/span>int<\/span> <\/span>PRIMARY KEY<\/span> <\/span>identity<\/span>(<\/span>1<\/span>,<\/span>1<\/span>),<\/span><\/span>\ntoodeNimi <\/span>varchar<\/span>(<\/span>50<\/span>),<\/span><\/span>\nhind <\/span>int<\/span>);<\/span><\/span>\n--loome tabeli, mis t\u00e4idab trigger<\/span><\/span>\nCREATE<\/span> <\/span>TABLE<\/span> <\/span>logi<\/span>(<\/span><\/span>\nid <\/span>int<\/span> <\/span>PRIMARY KEY<\/span> <\/span>identity<\/span>(<\/span>1<\/span>,<\/span>1<\/span>),<\/span><\/span>\nkasutaja <\/span>varchar<\/span>(<\/span>100<\/span>),<\/span><\/span>\nkuupaev <\/span>datetime<\/span>,<\/span><\/span>\nsisestatudAndmed <\/span>text<\/span>);<\/span><\/span>\n-- INSERT TRIGGER - trigger, mis j\u00e4lgib andmete lisamine tabelisse ja teeb vastava kirje tabelis logi<\/span><\/span>\nCREATE<\/span> <\/span>TRIGGER<\/span> <\/span>toodeLisamine<\/span><\/span>\nON<\/span> toode <\/span>--tabel, mis j\u00e4lgitakse<\/span><\/span>\nFOR<\/span> <\/span>INSERT<\/span><\/span>\nAS<\/span><\/span>\nINSERT INTO<\/span> logi(kasutaja, kuupaev, sisestatudAndmed)<\/span><\/span>\nSELECT<\/span><\/span>\nUSER,<\/span><\/span>\nGETDATE<\/span>(),<\/span><\/span>\nCONCAT<\/span>(<\/span>'Lisatud andmed: '<\/span>, <\/span>inserted<\/span>.<\/span>toodenimi<\/span>, <\/span>', '<\/span>, <\/span>inserted<\/span>.<\/span>hind<\/span>)<\/span><\/span>\nFROM<\/span> inserted;<\/span><\/span>\n--kontroll<\/span><\/span>\n--kontrollimiseks lisame toode<\/span><\/span>\nINSERT INTO<\/span> toode(toodeNimi, hind)<\/span><\/span>\nVALUES<\/span> (<\/span>'magus \u00f5un'<\/span>, <\/span>10<\/span>);<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> toode;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\nINSERT INTO<\/span> toode(toodeNimi, hind)<\/span><\/span>\nVALUES<\/span> (<\/span>'ilus pirn'<\/span>, <\/span>30<\/span>);<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> toode;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\nCREATE<\/span> <\/span>TRIGGER<\/span> <\/span>toodeKustutamine<\/span><\/span>\nON<\/span> toode <\/span>--tabel, mis j\u00e4lgitakse<\/span><\/span>\nFOR<\/span> <\/span>DELETE<\/span><\/span>\nAS<\/span><\/span>\nINSERT INTO<\/span> logi(kasutaja, kuupaev, sisestatudAndmed)<\/span><\/span>\nSELECT<\/span><\/span>\nUSER,<\/span><\/span>\nGETDATE<\/span>(),<\/span><\/span>\nCONCAT<\/span>(<\/span>'Kustutatud andmed: '<\/span>, <\/span>deleted<\/span>.<\/span>toodenimi<\/span>, <\/span>', '<\/span>, <\/span>deleted<\/span>.<\/span>hind<\/span>)<\/span><\/span>\nFROM<\/span> deleted;<\/span><\/span>\n--kontrollimiseks kustutame toode tabelis toode<\/span><\/span>\nDELETE<\/span> <\/span>FROM<\/span> toode<\/span><\/span>\nWHERE<\/span> toodeId<\/span>=<\/span>1<\/span>;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> toode;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\nCREATE<\/span> <\/span>TRIGGER<\/span> <\/span>toodeUuendamine<\/span><\/span>\nON<\/span> toode <\/span>--tabel, mis j\u00e4lgitakse<\/span><\/span>\nFOR<\/span> <\/span>UPDATE<\/span><\/span>\nAS<\/span><\/span>\nINSERT INTO<\/span> logi(kasutaja, kuupaev, sisestatudAndmed)<\/span><\/span>\nSELECT<\/span><\/span>\nUSER,<\/span><\/span>\nGETDATE<\/span>(),<\/span><\/span>\nCONCAT<\/span>(<\/span>'Vanad andmed: '<\/span>, <\/span>deleted<\/span>.<\/span>toodenimi<\/span>, <\/span>', '<\/span>, <\/span>deleted<\/span>.<\/span>hind<\/span>, <\/span>'; Uued andmed: '<\/span>, <\/span>inserted<\/span>.<\/span>toodenimi<\/span>, <\/span>', '<\/span>, <\/span>inserted<\/span>.<\/span>hind<\/span>)<\/span><\/span>\nFROM<\/span> deleted <\/span>INNER JOIN<\/span> inserted<\/span><\/span>\nON<\/span> <\/span>deleted<\/span>.<\/span>toodeId<\/span>=<\/span>inserted<\/span>.<\/span>toodeId<\/span>;<\/span><\/span>\n--kontrollimiseks uuendame toode<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> toode;<\/span><\/span>\nUPDATE<\/span> toode <\/span>SET<\/span> toodeNimi<\/span>=<\/span>'orange melon'<\/span><\/span>\nWHERE<\/span> toodeId<\/span>=<\/span>2<\/span>;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> toode;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\nCREATE<\/span> <\/span>TABLE<\/span> <\/span>categories<\/span> (<\/span><\/span>\n\tcategory_id <\/span>INT<\/span> <\/span>IDENTITY<\/span> (<\/span>1<\/span>, <\/span>1<\/span>) <\/span>PRIMARY KEY<\/span>,<\/span><\/span>\n\tcategory_name <\/span>VARCHAR<\/span> (<\/span>255<\/span>) <\/span>NOT NULL<\/span><\/span>\n);<\/span><\/span>\nCREATE<\/span> <\/span>TABLE<\/span> <\/span>brands<\/span> (<\/span><\/span>\n\tbrand_id <\/span>INT<\/span> <\/span>IDENTITY<\/span> (<\/span>1<\/span>, <\/span>1<\/span>) <\/span>PRIMARY KEY<\/span>,<\/span><\/span>\n\tbrand_name <\/span>VARCHAR<\/span> (<\/span>255<\/span>) <\/span>NOT NULL<\/span><\/span>\n);<\/span><\/span>\nCREATE<\/span> <\/span>TABLE<\/span> <\/span>products<\/span> (<\/span><\/span>\n\tproduct_id <\/span>INT<\/span> <\/span>IDENTITY<\/span> (<\/span>1<\/span>, <\/span>1<\/span>) <\/span>PRIMARY KEY<\/span>,<\/span><\/span>\n\tproduct_name <\/span>VARCHAR<\/span> (<\/span>255<\/span>) <\/span>NOT NULL<\/span>,<\/span><\/span>\n\tbrand_id <\/span>INT<\/span> <\/span>NOT NULL<\/span>,<\/span><\/span>\n\tcategory_id <\/span>INT<\/span> <\/span>NOT NULL<\/span>,<\/span><\/span>\n\tmodel_year <\/span>SMALLINT<\/span> <\/span>NOT NULL<\/span>,<\/span><\/span>\n\tlist_price <\/span>DECIMAL<\/span> (<\/span>10<\/span>, <\/span>2<\/span>) <\/span>NOT NULL<\/span>,<\/span><\/span>\n\t<\/span>FOREIGN KEY<\/span> (category_id) <\/span><\/span>\n        <\/span>REFERENCES<\/span> categories (category_id) <\/span><\/span>\n        <\/span>ON DELETE CASCADE<\/span> <\/span>ON<\/span> <\/span>UPDATE<\/span> CASCADE,<\/span><\/span>\n\t<\/span>FOREIGN KEY<\/span> (brand_id) <\/span><\/span>\n        <\/span>REFERENCES<\/span> brands (brand_id) <\/span><\/span>\n        <\/span>ON DELETE CASCADE<\/span> <\/span>ON<\/span> <\/span>UPDATE<\/span> CASCADE<\/span><\/span>\n);<\/span><\/span>\nCREATE<\/span> <\/span>TABLE<\/span> <\/span>product_audits<\/span>(<\/span><\/span>\n    change_id <\/span>INT<\/span> <\/span>IDENTITY<\/span> <\/span>PRIMARY KEY<\/span>,<\/span><\/span>\n    product_id <\/span>INT<\/span> <\/span>NOT NULL<\/span>,<\/span><\/span>\n    product_name <\/span>VARCHAR<\/span>(<\/span>255<\/span>) <\/span>NOT NULL<\/span>,<\/span><\/span>\n    brand_id <\/span>INT<\/span> <\/span>NOT NULL<\/span>,<\/span><\/span>\n    category_id <\/span>INT<\/span> <\/span>NOT NULL<\/span>,<\/span><\/span>\n    model_year <\/span>SMALLINT<\/span> <\/span>NOT NULL<\/span>,<\/span><\/span>\n    list_price <\/span>DEC<\/span>(<\/span>10<\/span>,<\/span>2<\/span>) <\/span>NOT NULL<\/span>,<\/span><\/span>\n    updated_at <\/span>DATETIME<\/span> <\/span>NOT NULL<\/span>,<\/span><\/span>\n    operation <\/span>CHAR<\/span>(<\/span>3<\/span>) <\/span>NOT NULL<\/span>,<\/span><\/span>\n    <\/span>CHECK<\/span>(operation <\/span>=<\/span> <\/span>'INS'<\/span> <\/span>or<\/span> operation<\/span>=<\/span>'DEL'<\/span>)<\/span><\/span>\n);<\/span><\/span>\nCREATE<\/span> <\/span>TRIGGER<\/span> <\/span>trg_product_audit<\/span><\/span>\nON<\/span> products<\/span><\/span>\nAFTER<\/span> <\/span>INSERT<\/span>, <\/span>DELETE<\/span><\/span>\nAS<\/span><\/span>\nBEGIN<\/span><\/span>\n    <\/span>SET<\/span> <\/span>NOCOUNT<\/span> <\/span>ON<\/span>;<\/span><\/span>\n    <\/span>INSERT INTO<\/span> product_audits(<\/span><\/span>\n        product_id, <\/span><\/span>\n        product_name,<\/span><\/span>\n        brand_id,<\/span><\/span>\n        category_id,<\/span><\/span>\n        model_year,<\/span><\/span>\n        list_price, <\/span><\/span>\n        updated_at, <\/span><\/span>\n        operation<\/span><\/span>\n    )<\/span><\/span>\n    <\/span>SELECT<\/span><\/span>\n        <\/span>i<\/span>.<\/span>product_id<\/span>,<\/span><\/span>\n        product_name,<\/span><\/span>\n        brand_id,<\/span><\/span>\n        category_id,<\/span><\/span>\n        model_year,<\/span><\/span>\n        <\/span>i<\/span>.<\/span>list_price<\/span>,<\/span><\/span>\n        <\/span>GETDATE<\/span>(),<\/span><\/span>\n        <\/span>'INS'<\/span><\/span>\n    <\/span>FROM<\/span><\/span>\n        inserted i<\/span><\/span>\n    <\/span>UNION ALL<\/span><\/span>\n    <\/span>SELECT<\/span><\/span>\n        <\/span>d<\/span>.<\/span>product_id<\/span>,<\/span><\/span>\n        product_name,<\/span><\/span>\n        brand_id,<\/span><\/span>\n        category_id,<\/span><\/span>\n        model_year,<\/span><\/span>\n        <\/span>d<\/span>.<\/span>list_price<\/span>,<\/span><\/span>\n        <\/span>GETDATE<\/span>(),<\/span><\/span>\n        <\/span>'DEL'<\/span><\/span>\n    <\/span>FROM<\/span><\/span>\n        deleted d;<\/span><\/span>\nEND<\/span><\/span>\nINSERT INTO<\/span> categories (category_name) <\/span>VALUES<\/span> (<\/span>'Electronics'<\/span>);<\/span><\/span>\nINSERT INTO<\/span> brands (brand_name) <\/span>VALUES<\/span> (<\/span>'TestBrand'<\/span>);<\/span><\/span>\nINSERT INTO<\/span> products(<\/span><\/span>\n    product_name, <\/span><\/span>\n    brand_id, <\/span><\/span>\n    category_id, <\/span><\/span>\n    model_year, <\/span><\/span>\n    list_price<\/span><\/span>\n)<\/span><\/span>\nVALUES<\/span> (<\/span><\/span>\n    <\/span>'Test product'<\/span>,<\/span><\/span>\n    <\/span>1<\/span>,<\/span><\/span>\n    <\/span>1<\/span>,<\/span><\/span>\n    <\/span>2018<\/span>,<\/span><\/span>\n    <\/span>599<\/span><\/span>\n);<\/span><\/span>\nSELECT<\/span> <\/span><\/span>\n    <\/span>*<\/span> <\/span><\/span>\nFROM<\/span> <\/span><\/span>\n    product_audits;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Aleksandra Semjonova \u00fclesanne:<\/p>\n\n\n\n
SQL Server<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
CREATE<\/span> <\/span>DATABASE<\/span> <\/span>Filmid<\/span>;<\/span><\/span>\nUSE<\/span> Filmid<\/span><\/span>\nCREATE<\/span> <\/span>TABLE<\/span> <\/span>Filmid<\/span>(<\/span><\/span>\nfilimidID <\/span>int<\/span> <\/span>PRIMARY KEY<\/span> <\/span>identity<\/span>(<\/span>1<\/span>,<\/span>1<\/span>),<\/span><\/span>\nfilmNimi <\/span>varchar<\/span>(<\/span>50<\/span>),<\/span><\/span>\nlavastaja <\/span>varchar<\/span>(<\/span>50<\/span>),<\/span><\/span>\nfilmiKestus <\/span>int<\/span>);<\/span><\/span>\nCREATE<\/span> <\/span>TABLE<\/span> <\/span>logi<\/span>(<\/span><\/span>\nlogiID <\/span>int<\/span> <\/span>PRIMARY KEY<\/span> <\/span>identity<\/span>(<\/span>1<\/span>,<\/span>1<\/span>),<\/span><\/span>\nkuupaev <\/span>datetime<\/span>,<\/span><\/span>\nandmed <\/span>text<\/span>,<\/span><\/span>\nkasutaja <\/span>varchar<\/span>(<\/span>50<\/span>));<\/span><\/span>\nCREATE<\/span> <\/span>TRIGGER<\/span> <\/span>insertFilmid<\/span><\/span>\nON<\/span> Filmid<\/span><\/span>\nFOR<\/span> <\/span>INSERT<\/span><\/span>\nAS<\/span><\/span>\nINSERT INTO<\/span> logi(kuupaev, andmed, kasutaja)<\/span><\/span>\nSELECT<\/span><\/span>\nGETDATE<\/span>(),<\/span><\/span>\nCONCAT<\/span>(<\/span>'Lisatud andmed: '<\/span>, <\/span>inserted<\/span>.<\/span>filmNimi<\/span>, <\/span>', '<\/span>, <\/span>inserted<\/span>.<\/span>lavastaja<\/span>, <\/span>', '<\/span>, <\/span>inserted<\/span>.<\/span>filimidID<\/span>),<\/span><\/span>\nUSER<\/span><\/span>\nFROM<\/span> inserted;<\/span><\/span>\nCREATE<\/span> <\/span>TRIGGER<\/span> <\/span>deleteFilmid<\/span><\/span>\nON<\/span> Filmid<\/span><\/span>\nFOR<\/span> <\/span>DELETE<\/span><\/span>\nAS<\/span><\/span>\nINSERT INTO<\/span> logi(kuupaev, andmed, kasutaja)<\/span><\/span>\nSELECT<\/span><\/span>\nGETDATE<\/span>(),<\/span><\/span>\nCONCAT<\/span>(<\/span>'Kustutanud andmed: '<\/span>, <\/span>deleted<\/span>.<\/span>filmNimi<\/span>, <\/span>', '<\/span>, <\/span>deleted<\/span>.<\/span>lavastaja<\/span>, <\/span>', '<\/span>, <\/span>deleted<\/span>.<\/span>filimidID<\/span>),<\/span><\/span>\nUSER<\/span><\/span>\nFROM<\/span> deleted;<\/span><\/span>\n-- produtsent lisamine graafiliselt<\/span><\/span>\nGRANT<\/span> <\/span>INSERT<\/span>, <\/span>DELETE<\/span> <\/span>TO<\/span> produtsent;<\/span><\/span>\nGRANT<\/span> <\/span>SELECT<\/span>, <\/span>INSERT<\/span>, <\/span>DELETE<\/span> <\/span>ON<\/span> Filmid <\/span>TO<\/span> produtsent;<\/span><\/span>\n-- admin testid<\/span><\/span>\nINSERT INTO<\/span> Filmid(filmNimi, lavastaja, filmiKestus)<\/span><\/span>\nVALUES<\/span> (<\/span>'test'<\/span>, <\/span>'test'<\/span>, <\/span>1234<\/span>);<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> Filmid;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\nDELETE<\/span> <\/span>FROM<\/span> Filmid <\/span>WHERE<\/span> filimidID<\/span>=<\/span>1<\/span>;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> Filmid;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\n-- kasutaja testid<\/span><\/span>\nINSERT INTO<\/span> Filmid(filmNimi, lavastaja, filmiKestus)<\/span><\/span>\nVALUES<\/span> (<\/span>'test'<\/span>, <\/span>'test'<\/span>, <\/span>1234<\/span>);<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> Filmid;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\nDELETE<\/span> <\/span>FROM<\/span> Filmid <\/span>WHERE<\/span> filimidID<\/span>=<\/span>1<\/span>;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> Filmid;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\n-- kasutaja testid<\/span><\/span>\nUSE<\/span> Filmid;<\/span><\/span>\nINSERT INTO<\/span> Filmid(filmNimi, lavastaja, filmiKestus)<\/span><\/span>\nVALUES<\/span> (<\/span>'test'<\/span>, <\/span>'test'<\/span>, <\/span>1234<\/span>);<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> Filmid;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span>\nDELETE<\/span> <\/span>FROM<\/span> Filmid <\/span>WHERE<\/span> filimidID<\/span>=<\/span>3<\/span>;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> Filmid;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
XAMPP<\/p>\n\n\n\n
Tabeli loomine<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
CREATE<\/span> <\/span>TABLE<\/span> <\/span>Filmid<\/span>(<\/span><\/span>\nfilimidID <\/span>int<\/span> <\/span>PRIMARY KEY<\/span> AUTO_INCREMENT,<\/span><\/span>\nfilmNimi <\/span>varchar<\/span>(<\/span>50<\/span>),<\/span><\/span>\nlavastaja <\/span>varchar<\/span>(<\/span>50<\/span>),<\/span><\/span>\nfilmiKestus <\/span>int<\/span>);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
CREATE<\/span> <\/span>TABLE<\/span> <\/span>logi<\/span>(<\/span><\/span>\nlogiID <\/span>int<\/span> <\/span>PRIMARY KEY<\/span> AUTO_INCREMENT,<\/span><\/span>\nkuupaev <\/span>datetime<\/span>,<\/span><\/span>\nandmed <\/span>text<\/span>,<\/span><\/span>\nkasutaja <\/span>varchar<\/span>(<\/span>50<\/span>));<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Triggeri loomine<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
INSERT INTO<\/span> logi(kuupaev, andmed, kasutaja)<\/span><\/span>\nSELECT<\/span><\/span>\nNOW<\/span>(),<\/span><\/span>\nCONCAT<\/span>(<\/span>'Lisatud andmed: '<\/span>, <\/span>new<\/span>.<\/span>filmNimi<\/span>, <\/span>', '<\/span>, <\/span>new<\/span>.<\/span>lavastaja<\/span>, <\/span>', '<\/span>, <\/span>new<\/span>.<\/span>filimidID<\/span>),<\/span><\/span>\nUSER()<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
INSERT INTO<\/span> logi(kuupaev, andmed, kasutaja)<\/span><\/span>\nSELECT<\/span><\/span>\nNOW<\/span>(),<\/span><\/span>\nCONCAT<\/span>(<\/span>'Kustutanud andmed: '<\/span>, <\/span>old<\/span>.<\/span>filmNimi<\/span>, <\/span>', '<\/span>, <\/span>old<\/span>.<\/span>lavastaja<\/span>, <\/span>', '<\/span>, <\/span>old<\/span>.<\/span>filimidID<\/span>),<\/span><\/span>\nUSER()<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Kasutaja loomine<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Kasutaja \u00f5igused<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Kasutaja testid<\/p>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
INSERT INTO<\/span> Filmid(filmNimi, lavastaja, filmiKestus)<\/span><\/span>\nVALUES<\/span> (<\/span>'test'<\/span>, <\/span>'test'<\/span>, <\/span>1234<\/span>);<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> Filmid;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
SQL<\/span><\/path><\/path><\/svg><\/span>
DELETE<\/span> <\/span>FROM<\/span> Filmid <\/span>WHERE<\/span> filimidID<\/span>=<\/span>1<\/span>;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> Filmid;<\/span><\/span>\nSELECT<\/span> <\/span>*<\/span> <\/span>FROM<\/span> logi;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\"\"<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Trigger – protsess, mille abil tema sisse kirjutatud tegevused automatselt k\u00e4ivitakse. Aleksandra Semjonova \u00fclesanne: SQL Server XAMPP Tabeli loomine Triggeri loomine Kasutaja loomine Kasutaja \u00f5igused Kasutaja testid<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1066","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/1066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/comments?post=1066"}],"version-history":[{"count":8,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/1066\/revisions"}],"predecessor-version":[{"id":1139,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/1066\/revisions\/1139"}],"wp:attachment":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/media?parent=1066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}