{"id":410,"date":"2024-01-15T11:05:20","date_gmt":"2024-01-15T09:05:20","guid":{"rendered":"https:\/\/aleksandraleksejev.wordpress.com\/?page_id=410"},"modified":"2024-01-15T11:05:20","modified_gmt":"2024-01-15T09:05:20","slug":"autorent-andmebaas-localhost","status":"publish","type":"page","link":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/","title":{"rendered":"AUTORENT ANDMEBAAS \/ LOCALHOST"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\"><br>CREATE TABLE auto(\nautoID int not null Primary key AUTO_INCREMENT,\nregNumber char(6) UNIQUE,\nmarkID int,\nvarv varchar(20),\nv_aasta int,\nkaigukastID int,\nkm decimal(6,2)\n);\nSELECT * FROM auto<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE mark(\nmarkID int not null Primary key AUTO_INCREMENT,\nautoMark varchar(30) UNIQUE\n);<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">INSERT INTO mark(autoMark)\nVALUES ('Ziguli');\nINSERT INTO mark(autoMark)\nVALUES ('Lambordzini');\nINSERT INTO mark(autoMark)\nVALUES ('BMW');\nSELECT * FROM mark;<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE kaigukast(\nkaigukastID int not null Primary key AUTO_INCREMENT,\nkaigukast varchar(30) UNIQUE\n);\nINSERT INTO kaigukast(kaigukast)\nVALUES ('Automaat');\nINSERT INTO kaigukast(kaigukast)\nVALUES ('Manual');\nSELECT * FROM kaigukast;<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLE auto\nADD FOREIGN KEY (markID) REFERENCES mark(markID);\nALTER TABLE auto\nADD FOREIGN KEY (kaigukastID) REFERENCES kaigukast(kaigukastID);<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE klient(\nklientID int not null primary key AUTO_INCREMENT,\nkliendiNimi varchar(50),\ntelefon varchar(20),\naadress varchar(50),\nsoiduKogemus varchar(30)\n)<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE rendiLeping(\nlepingID int not null primary key AUTO_INCREMENT,\nrendiAlgus date,\nrendiLopp date,\nklientID int,\nregNumber varchar(6),\nrendiKestvus int,\nhindKokku decimal(5,2),\ntootajaID int\n)\n<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE tootaja(\ntootajaID int not null primary key AUTO_INCREMENT,\ntootajaNimi varchar(50),\nametID int)<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLE rendiLeping add FOREIGN KEY (klientID) REFERENCES klient(klientID)\nALTER TABLE rendiLeping add FOREIGN KEY (tootajaID) REFERENCES tootaja(tootajaID)\nALTER TABLE rendileping add FOREIGN KEY (regNumber) REFERENCES auto(regNumber)<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE Amet(\nametID int not null PRIMARY KEY AUTO_INCREMENT,\nametNimi varchar(20))\nALTER TABLE tootaja add FOREIGN KEY (ametID) REFERENCES amet(ametID)<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT auto.regNumber, kaigukast.kaigukast\nFROM auto, kaigukast where kaigukast.kaigukastID=auto.kaigukastID\n<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-11-1.png?w=176\" alt=\"\" class=\"wp-image-735\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT auto.regnumber, mark.automark\nFROM auto INNER JOIN mark ON mark.markID=auto.markID<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-12-1.png?w=187\" alt=\"\" class=\"wp-image-737\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT klient.kliendiNimi, rendileping.lepingID, auto.regNumber FROM rendileping \nINNER JOIN klient ON rendileping.klientID=klient.klientID \nINNER JOIN auto on rendileping.regNumber=auto.regNumber<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-13-1.png?w=251\" alt=\"\" class=\"wp-image-739\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT kaigukast.kaigukast, Count(auto.autoID) AS kogus\nFROM auto, kaigukast\nwhere auto.kaigukastID=kaigukast.kaigukastID GROUP BY kaigukast.kaigukast<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-15-1.png?w=384\" alt=\"\" class=\"wp-image-745\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT auto.regNumber, tootaja.tootajaNimi FROM auto,tootaja,rendileping where tootaja.tootajaID=rendileping.tootajaID and rendileping.regNumber=auto.regNumber<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-14-1.png?w=176\" alt=\"\" class=\"wp-image-744\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT auto.regNumber, tootaja.tootajaNimi FROM auto,tootaja,rendileping where tootaja.tootajaID=rendileping.tootajaID and rendileping.regNumber=auto.regNumber and (rendileping.rendiAlgus BETWEEN '2022-05-02' and '2022-05-12')<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-16-1.png?w=191\" alt=\"\" class=\"wp-image-748\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT COUNT(auto.autoID) AS Autod, SUM(rendileping.hindKokku) AS Hind from rendiLeping, auto WHERE rendiAlgus between '2022-05-01' and '2022-10-01'<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-17-1.png?w=129\" alt=\"\" class=\"wp-image-750\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">BEGIN\nINSERT INTO mark(autoMark)\nVALUES (uusAutoMark);\nSELECT * FROM mark;\nEND<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-1.png?w=586\" alt=\"\" class=\"wp-image-753\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">BEGIN\nSELECT autoMark FROM mark\nWHERE autoMark LIKE CONCAT (Taht, '%');\nEND<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-1-2.png?w=666\" alt=\"\" class=\"wp-image-756\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">BEGIN\nDELETE FROM mark WHERE markID=id;\nSELECT * FROM mark;\nEND<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-2.png?w=670\" alt=\"\" class=\"wp-image-760\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">BEGIN\nUPDATE mark SET autoMark=uusAutoMark\nWHERE markID=id;\nSELECT * FROM mark;\nEND<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-3-1.png?w=677\" alt=\"\" class=\"wp-image-762\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">BEGIN\nDELETE FROM rendileping WHERE lepingID=id;\nSELECT * FROM rendileping;\nEND<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-4-1.png?w=662\" alt=\"\" class=\"wp-image-764\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">BEGIN\nINSERT INTO amet(ametNimi)\nVALUES (lisaAmet);\nUPDATE amet SET ametNimi=uundadaAmet WHERE ametID=id;\nSELECT * FROM amet;\nEND<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-5.png?w=670\" alt=\"\" class=\"wp-image-766\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-6.png?w=238\" alt=\"\" class=\"wp-image-768\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-7.png?w=692\" alt=\"\" class=\"wp-image-770\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-9-1.png?w=1024\" alt=\"\" class=\"wp-image-773\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-10.png?w=1024\" alt=\"\" class=\"wp-image-774\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/pilt-11-1.png?w=603\" alt=\"\" class=\"wp-image-776\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-410","page","type-page","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID int, km decimal(6,2) ); SELECT * FROM auto CREATE TABLE mark( markID int not null Primary key AUTO_INCREMENT, autoMark varchar(30) UNIQUE ); INSERT INTO mark(autoMark) VALUES (&#039;Ziguli&#039;); INSERT INTO mark(autoMark) VALUES (&#039;Lambordzini&#039;); INSERT INTO mark(autoMark)\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"google-site-verification\" content=\"tkbGFUaoRuR10CiaeVP2r2eJVzWl5wL0lGtASf0HS_s\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Aleksandr Aleksejev Protfoolio - Noorem takvaraarendaja\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio\" \/>\n\t\t<meta property=\"og:description\" content=\"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID int, km decimal(6,2) ); SELECT * FROM auto CREATE TABLE mark( markID int not null Primary key AUTO_INCREMENT, autoMark varchar(30) UNIQUE ); INSERT INTO mark(autoMark) VALUES (&#039;Ziguli&#039;); INSERT INTO mark(autoMark) VALUES (&#039;Lambordzini&#039;); INSERT INTO mark(autoMark)\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-01-15T09:05:20+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-01-15T09:05:20+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio\" \/>\n\t\t<meta name=\"twitter:description\" content=\"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID int, km decimal(6,2) ); SELECT * FROM auto CREATE TABLE mark( markID int not null Primary key AUTO_INCREMENT, autoMark varchar(30) UNIQUE ); INSERT INTO mark(autoMark) VALUES (&#039;Ziguli&#039;); INSERT INTO mark(autoMark) VALUES (&#039;Lambordzini&#039;); INSERT INTO mark(autoMark)\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3#listItem\",\"position\":1,\"name\":\"\\u0413\\u043b\\u0430\\u0432\\u043d\\u0430\\u044f \\u0441\\u0442\\u0440\\u0430\\u043d\\u0438\\u0446\\u0430\",\"item\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#listItem\",\"name\":\"AUTORENT ANDMEBAAS \\\/ LOCALHOST\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#listItem\",\"position\":2,\"name\":\"AUTORENT ANDMEBAAS \\\/ LOCALHOST\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3#listItem\",\"name\":\"\\u0413\\u043b\\u0430\\u0432\\u043d\\u0430\\u044f \\u0441\\u0442\\u0440\\u0430\\u043d\\u0438\\u0446\\u0430\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#organization\",\"name\":\"Aleksandr Aleksejev Protfoolio\",\"description\":\"Noorem takvaraarendaja\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/extendify-demo-logo.png\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#organizationLogo\",\"width\":96,\"height\":97},\"image\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#organizationLogo\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#webpage\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/\",\"name\":\"AUTORENT ANDMEBAAS \\\/ LOCALHOST - Aleksandr Aleksejev Protfoolio\",\"description\":\"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID int, km decimal(6,2) ); SELECT * FROM auto CREATE TABLE mark( markID int not null Primary key AUTO_INCREMENT, autoMark varchar(30) UNIQUE ); INSERT INTO mark(autoMark) VALUES ('Ziguli'); INSERT INTO mark(autoMark) VALUES ('Lambordzini'); INSERT INTO mark(autoMark)\",\"inLanguage\":\"et\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#breadcrumblist\"},\"datePublished\":\"2024-01-15T11:05:20+00:00\",\"dateModified\":\"2024-01-15T11:05:20+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#website\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\",\"name\":\"Aleksandr Aleksejev Protfoolio\",\"description\":\"Noorem takvaraarendaja\",\"inLanguage\":\"et\",\"publisher\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio","description":"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID int, km decimal(6,2) ); SELECT * FROM auto CREATE TABLE mark( markID int not null Primary key AUTO_INCREMENT, autoMark varchar(30) UNIQUE ); INSERT INTO mark(autoMark) VALUES ('Ziguli'); INSERT INTO mark(autoMark) VALUES ('Lambordzini'); INSERT INTO mark(autoMark)","canonical_url":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"tkbGFUaoRuR10CiaeVP2r2eJVzWl5wL0lGtASf0HS_s","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/aleksejev21.thkit.ee\/wp3#listItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/aleksejev21.thkit.ee\/wp3","nextItem":{"@type":"ListItem","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#listItem","name":"AUTORENT ANDMEBAAS \/ LOCALHOST"}},{"@type":"ListItem","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#listItem","position":2,"name":"AUTORENT ANDMEBAAS \/ LOCALHOST","previousItem":{"@type":"ListItem","@id":"https:\/\/aleksejev21.thkit.ee\/wp3#listItem","name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430"}}]},{"@type":"Organization","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#organization","name":"Aleksandr Aleksejev Protfoolio","description":"Noorem takvaraarendaja","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/","logo":{"@type":"ImageObject","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#organizationLogo","width":96,"height":97},"image":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#organizationLogo"}},{"@type":"WebPage","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#webpage","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/","name":"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio","description":"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID int, km decimal(6,2) ); SELECT * FROM auto CREATE TABLE mark( markID int not null Primary key AUTO_INCREMENT, autoMark varchar(30) UNIQUE ); INSERT INTO mark(autoMark) VALUES ('Ziguli'); INSERT INTO mark(autoMark) VALUES ('Lambordzini'); INSERT INTO mark(autoMark)","inLanguage":"et","isPartOf":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#website"},"breadcrumb":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#breadcrumblist"},"datePublished":"2024-01-15T11:05:20+00:00","dateModified":"2024-01-15T11:05:20+00:00"},{"@type":"WebSite","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#website","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/","name":"Aleksandr Aleksejev Protfoolio","description":"Noorem takvaraarendaja","inLanguage":"et","publisher":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#organization"}}]},"og:locale":"et_EE","og:site_name":"Aleksandr Aleksejev Protfoolio - Noorem takvaraarendaja","og:type":"article","og:title":"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio","og:description":"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID int, km decimal(6,2) ); SELECT * FROM auto CREATE TABLE mark( markID int not null Primary key AUTO_INCREMENT, autoMark varchar(30) UNIQUE ); INSERT INTO mark(autoMark) VALUES ('Ziguli'); INSERT INTO mark(autoMark) VALUES ('Lambordzini'); INSERT INTO mark(autoMark)","og:url":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/","og:image":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png","og:image:secure_url":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png","article:published_time":"2024-01-15T09:05:20+00:00","article:modified_time":"2024-01-15T09:05:20+00:00","twitter:card":"summary_large_image","twitter:title":"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio","twitter:description":"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID int, km decimal(6,2) ); SELECT * FROM auto CREATE TABLE mark( markID int not null Primary key AUTO_INCREMENT, autoMark varchar(30) UNIQUE ); INSERT INTO mark(autoMark) VALUES ('Ziguli'); INSERT INTO mark(autoMark) VALUES ('Lambordzini'); INSERT INTO mark(autoMark)","twitter:image":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/05\/extendify-demo-logo.png"},"aioseo_meta_data":{"post_id":"410","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2024-06-03 11:41:39","updated":"2025-06-05 07:48:05","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/aleksejev21.thkit.ee\/wp3\" title=\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\">\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tAUTORENT ANDMEBAAS \/ LOCALHOST\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","link":"https:\/\/aleksejev21.thkit.ee\/wp3"},{"label":"AUTORENT ANDMEBAAS \/ LOCALHOST","link":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/"}],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio\" \/>\n<meta property=\"og:description\" content=\"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/\" \/>\n<meta property=\"og:site_name\" content=\"Aleksandr Aleksejev Protfoolio\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100011831793026&amp;locale=ru_RU\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-11-1.png?w=176\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Eeldatav lugemisaeg\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/\",\"name\":\"AUTORENT ANDMEBAAS \\\/ LOCALHOST - Aleksandr Aleksejev Protfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rozkov21.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/image-11-1.png?w=176\",\"datePublished\":\"2024-01-15T09:05:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rozkov21.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/image-11-1.png?w=176\",\"contentUrl\":\"https:\\\/\\\/rozkov21.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/image-11-1.png?w=176\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/autorent-andmebaas-localhost\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AUTORENT ANDMEBAAS \\\/ LOCALHOST\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#website\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\",\"name\":\"Aleksandr Aleksejev Portfoolio\",\"description\":\"Noorem takvaraarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#organization\",\"name\":\"Aleksandr Aleksejev Portfoolio\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/image.png\",\"contentUrl\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/image.png\",\"width\":1200,\"height\":1200,\"caption\":\"Aleksandr Aleksejev Portfoolio\"},\"image\":{\"@id\":\"https:\\\/\\\/aleksejev21.thkit.ee\\\/wp3\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/profile.php?id=100011831793026&locale=ru_RU\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/","og_locale":"et_EE","og_type":"article","og_title":"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio","og_description":"CREATE TABLE auto( autoID int not null Primary key AUTO_INCREMENT, regNumber char(6) UNIQUE, markID int, varv varchar(20), v_aasta int, kaigukastID [&hellip;]","og_url":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/","og_site_name":"Aleksandr Aleksejev Protfoolio","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=100011831793026&locale=ru_RU","og_image":[{"url":"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-11-1.png?w=176","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Eeldatav lugemisaeg":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/","name":"AUTORENT ANDMEBAAS \/ LOCALHOST - Aleksandr Aleksejev Protfoolio","isPartOf":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#primaryimage"},"image":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#primaryimage"},"thumbnailUrl":"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-11-1.png?w=176","datePublished":"2024-01-15T09:05:20+00:00","breadcrumb":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#primaryimage","url":"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-11-1.png?w=176","contentUrl":"https:\/\/rozkov21.thkit.ee\/wp\/wp-content\/uploads\/2022\/05\/image-11-1.png?w=176"},{"@type":"BreadcrumbList","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/autorent-andmebaas-localhost\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/aleksejev21.thkit.ee\/wp3\/"},{"@type":"ListItem","position":2,"name":"AUTORENT ANDMEBAAS \/ LOCALHOST"}]},{"@type":"WebSite","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#website","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/","name":"Aleksandr Aleksejev Portfoolio","description":"Noorem takvaraarendaja","publisher":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aleksejev21.thkit.ee\/wp3\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Organization","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#organization","name":"Aleksandr Aleksejev Portfoolio","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/","logo":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#\/schema\/logo\/image\/","url":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/10\/image.png","contentUrl":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-content\/uploads\/2024\/10\/image.png","width":1200,"height":1200,"caption":"Aleksandr Aleksejev Portfoolio"},"image":{"@id":"https:\/\/aleksejev21.thkit.ee\/wp3\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/profile.php?id=100011831793026&locale=ru_RU"]}]}},"_links":{"self":[{"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/pages\/410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/comments?post=410"}],"version-history":[{"count":0,"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/pages\/410\/revisions"}],"wp:attachment":[{"href":"https:\/\/aleksejev21.thkit.ee\/wp3\/wp-json\/wp\/v2\/media?parent=410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}