{"id":517,"date":"2024-03-03T01:24:39","date_gmt":"2024-03-02T23:24:39","guid":{"rendered":"https:\/\/portfooandreei.wordpress.com\/?page_id=517"},"modified":"2024-03-28T13:39:04","modified_gmt":"2024-03-28T13:39:04","slug":"sql-routines","status":"publish","type":"page","link":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/","title":{"rendered":"SQL \u2013 Routines"},"content":{"rendered":"\n<p>\u0412\u044b\u0437\u043e\u0432 \u043f\u0440\u0438\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u044f , \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b tervist()<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PROCEDURE tervist()<br>LANGUAGE SQL<br>DETERMINISTIC<br>SQL SECURITY DEFINER<br>COMMENT \"Esimine prtoseduur\"<br>BEGIN<br>    SELECT 'hELLO wOLRD!';<br>END;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-1.png?w=840\" alt=\"\" class=\"wp-image-521\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>piletihind \u0431\u043e\u043b\u044c\u0448\u0435 \u0447\u0435\u043c 4<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN\n<br>SELECT filmNimetus, pilethind\n<br>FROM kinokava\n<br>WHERE pilethind &gt; Piletihind;\n<br>END<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-2.png?w=591\" alt=\"\" class=\"wp-image-523\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u041d\u0430\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 filmNimetus \u043f\u043e \u043f\u0435\u0440\u0432\u043e\u0439 \u0431\u0443\u043a\u0432\u0443 &#8220;P&#8221;. \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u043c Pulp Fiction<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN<br>    SELECT * from film<br>    WHERE filmNimetus LIKE CONCAT(valik, '%');<br>END<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-3.png?w=706\" alt=\"\" class=\"wp-image-525\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u043d\u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445&nbsp; (INSERT) \u0432 \u043b\u044e\u0431\u0443\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u043b\u044c\u043d\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438\u0437 \u0411\u0414 \u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440.<\/p>\n\n\n\n<p>\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u043d\u043e\u0432\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e\u0434 \u043d\u043e\u043c\u0435\u0440\u043e\u043c 8, Ilja Vorontsov, 1985-02-02<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN<br>INSERT INTO rezisoor(eesnimi, perenimi, sunniaasta)<br>VALUES(Ees,Pere,Sunni);<br>SELECT *from rezisoor;<br>END<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-4.png?w=982\" alt=\"\" class=\"wp-image-527\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u041d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u017eanr \u043f\u043e \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u043c\u0443 id.<\/p>\n\n\n\n<p>\u041f\u043e \u0434\u0430\u043d\u043d\u043e\u043c\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u0443 zandriD = 10, \u0423\u0414\u0410\u041b\u0415\u041d\u041e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN<br>DELETE FROM zanr<br>WHERE zanrID = removeID;<br>SELECT *FROM zanr;<br>END<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-5.png?w=491\" alt=\"\" class=\"wp-image-532\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u043d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043f\u043e \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u043c\u0443 \u0438\u043c\u0435\u043d\u0438 (\u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u043d\u0435 \u0434\u043e\u043b\u0436\u043d\u0430 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442\u044c \u0432\u0442\u043e\u0440\u0438\u0447\u043d\u043e\u0433\u043e \u043a\u043b\u044e\u0447\u0430). \u041a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0438 \u0432 \u0441\u0430\u043c\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435.<\/p>\n\n\n\n<p>\u0417\u0430\u043f\u0440\u043e\u0441 &#8220;\u043f\u043e\u0448\u0451\u043b&#8221; \u043f\u043e \u0432\u0435\u0442\u043a\u0435 ELSE, \u0442\u0430\u043a \u043a\u0430\u043a \u0442\u0430\u0431\u043b\u0438\u0446\u0430 &#8216;keel&#8217; \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 FOREIGN KEY<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN<br>    DECLARE Has_FKkey INT;<br>    -- \u043e\u0431\u044f\u0435\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0430\u044f \u0441 \u0442\u0438\u043f\u043e\u043c INT<br>    SELECT COUNT(*)<br>    -- \u0441\u0447\u0438\u0442\u0430\u0435\u0442 \u0412\u0421\u0415 \u0441\u0442\u0440\u043e\u043a\u0438<br>    INTO Has_FKkey<br>    -- \u0437\u0430\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u0442 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0432 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u0443\u044e Has_FKkey<br>    FROM information_schema.TABLE_CONSTRAINTS<br>    -- \u0432\u044b\u0431\u043e\u0440\u043a\u0430 \u0438\u0437 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<br>    WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = table_name AND CONSTRAINT_TYPE = 'FOREIGN KEY';<br>    -- \u0443\u0441\u043b\u043e\u0432\u0438\u0435 , \u0435\u0441\u043b\u0438 \u043f\u0440\u0438 \u0432\u043e\u0437\u0432\u0440\u0430\u0442\u0435 0 - \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043d\u0438\u0436\u043a\u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0435 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0435<br>    IF Has_FKkey = 0 THEN<br>        SET @f = CONCAT('DROP TABLE ', table_name);<br>        PREPARE stmt FROM @f;<br>        EXECUTE stmt;<br>        DEALLOCATE PREPARE stmt;<br>        SELECT('\u0422\u0430\u0431\u043b\u0438\u0446\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0430 \u0443\u0441\u043f\u0435\u0448\u043d\u043e.');<br>    ELSE<br>        -- \u0435\u0441\u043b\u0438 \u0443\u0441\u043b\u043e\u0432\u0438\u0435 \u043d\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u043e:<br>        SELECT ('\u041d\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u0443\u0434\u0430\u043b\u0438\u0442\u044c, \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 Foreign key.');<br>    END IF;<br>END<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-6.png?w=481\" alt=\"\" class=\"wp-image-534\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u041f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0430 ALTER \u0434\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b rezisoor, \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d \u043d\u043e\u0432\u044b\u0439 \u0441\u0442\u043e\u043b\u0431\u0435\u0446 oskarid<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN<br>SET @STMT = CONCAT(\"ALTER TABLE rezisoor ADD oskarid INT\");<br>PREPARE S FROM @STMT;<br>EXECUTE S;<br>DEALLOCATE PREPARE S;<br>END<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code has-primary-color has-text-color has-link-color wp-elements-85239f90cf80caedd88d0507a0ae7796\"><code>BEGIN<br>SET @STMT = CONCAT('ALTER TABLE rezisoor ADD', veerunimi, \"INT\");<br>PREPARE S FROM @STMT;<br>EXECUTE S;<br>DEALLOCATE PREPARE S;<br>END -- \u041d\u0415 \u0421\u041c\u041e\u0413 \u041f\u041e\u041d\u042f\u0422\u042c , \u041f\u041e\u0427\u0415\u041c\u0423 \u0412 \u0422\u0410\u041a\u041e\u0419 \u0412\u0415\u0420\u0421\u0418\u0418 \u0412\u042b\u0414\u0410\u0415\u0422 \u041e\u0428\u0418\u0411\u041a\u0423.<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-7.png?w=533\" alt=\"\" class=\"wp-image-538\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-8.png?w=704\" alt=\"\" class=\"wp-image-541\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u041f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0430 UPDATE \u0434\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b rezisoor, \u0440\u0435\u0436\u0438\u0441c\u0435\u0440 \u043f\u043e\u0434 rezisoorID 2 = \u0438\u0437\u043c\u0435\u043d\u0451\u043d \u043d\u0430 Ivan Ivanov<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>BEGIN<br>UPDATE rezisoor<br>\tSET eesnimi = eesnimi_new,perenimi = perenimi_new<br>WHERE rezisoorID = rezisoorID_new;<br>SELECT * from rezisoor;<br>END<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-9.png?w=835\" alt=\"\" class=\"wp-image-544\"\/><\/figure>\n\n\n\n<p><a href=\"https:\/\/trino.io\/docs\/current\/routines\/examples.html\">https:\/\/trino.io\/docs\/current\/routines\/examples.html<\/a><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0412\u044b\u0437\u043e\u0432 \u043f\u0440\u0438\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u044f , \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b tervist() piletihind \u0431\u043e\u043b\u044c\u0448\u0435 \u0447\u0435\u043c 4 \u041d\u0430\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 filmNimetus \u043f\u043e \u043f\u0435\u0440\u0432\u043e\u0439 \u0431\u0443\u043a\u0432\u0443 &#8220;P&#8221;. \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u043c Pulp Fiction \u043d\u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445&nbsp; (INSERT) \u0432 \u043b\u044e\u0431\u0443\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u043b\u044c\u043d\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438\u0437 \u0411\u0414 \u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440. \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u043d\u043e\u0432\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e\u0434 \u043d\u043e\u043c\u0435\u0440\u043e\u043c 8, Ilja Vorontsov, 1985-02-02 \u041d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u017eanr \u043f\u043e \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u043c\u0443 id. \u041f\u043e \u0434\u0430\u043d\u043d\u043e\u043c\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u0443 zandriD = 10,<a class=\"more-link\" href=\"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/\">Continue reading <span class=\"screen-reader-text\">&#8220;SQL \u2013 Routines&#8221;<\/span><\/a><\/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-517","page","type-page","status-publish","hentry","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL \u2013 Routines - \/ &Otilde;pimapp \/ Portfoolio<\/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:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL \u2013 Routines - \/ &Otilde;pimapp \/ Portfoolio\" \/>\n<meta property=\"og:description\" content=\"\u0412\u044b\u0437\u043e\u0432 \u043f\u0440\u0438\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u044f , \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b tervist() piletihind \u0431\u043e\u043b\u044c\u0448\u0435 \u0447\u0435\u043c 4 \u041d\u0430\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 filmNimetus \u043f\u043e \u043f\u0435\u0440\u0432\u043e\u0439 \u0431\u0443\u043a\u0432\u0443 &#8220;P&#8221;. \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u043c Pulp Fiction \u043d\u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445&nbsp; (INSERT) \u0432 \u043b\u044e\u0431\u0443\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u043b\u044c\u043d\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438\u0437 \u0411\u0414 \u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440. \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u043d\u043e\u0432\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e\u0434 \u043d\u043e\u043c\u0435\u0440\u043e\u043c 8, Ilja Vorontsov, 1985-02-02 \u041d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u017eanr \u043f\u043e \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u043c\u0443 id. \u041f\u043e \u0434\u0430\u043d\u043d\u043e\u043c\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u0443 zandriD = 10,Continue reading &quot;SQL \u2013 Routines&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/\" \/>\n<meta property=\"og:site_name\" content=\"\/ &Otilde;pimapp \/ Portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T13:39:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-1.png?w=840\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/sql-routines\\\/\",\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/sql-routines\\\/\",\"name\":\"SQL \u2013 Routines - \\\/ &Otilde;pimapp \\\/ Portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/sql-routines\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/sql-routines\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/portfooandreei.files.wordpress.com\\\/2024\\\/03\\\/image-1.png?w=840\",\"datePublished\":\"2024-03-02T23:24:39+00:00\",\"dateModified\":\"2024-03-28T13:39:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/sql-routines\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/sql-routines\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/sql-routines\\\/#primaryimage\",\"url\":\"https:\\\/\\\/portfooandreei.files.wordpress.com\\\/2024\\\/03\\\/image-1.png?w=840\",\"contentUrl\":\"https:\\\/\\\/portfooandreei.files.wordpress.com\\\/2024\\\/03\\\/image-1.png?w=840\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/sql-routines\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL \u2013 Routines\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/#website\",\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/\",\"name\":\"\\\/ &Otilde;pimapp \\\/ Portfoolio\",\"description\":\"Welcome to my WP page.\",\"publisher\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/#organization\",\"name\":\"\\\/ &Otilde;pimapp \\\/ Portfoolio\",\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/cropped-logo.png\",\"contentUrl\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/cropped-logo.png\",\"width\":240,\"height\":240,\"caption\":\"\\\/ &Otilde;pimapp \\\/ Portfoolio\"},\"image\":{\"@id\":\"https:\\\/\\\/andreitupits23.thkit.ee\\\/WP\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL \u2013 Routines - \/ &Otilde;pimapp \/ Portfoolio","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:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/","og_locale":"en_GB","og_type":"article","og_title":"SQL \u2013 Routines - \/ &Otilde;pimapp \/ Portfoolio","og_description":"\u0412\u044b\u0437\u043e\u0432 \u043f\u0440\u0438\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u044f , \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b tervist() piletihind \u0431\u043e\u043b\u044c\u0448\u0435 \u0447\u0435\u043c 4 \u041d\u0430\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0435 filmNimetus \u043f\u043e \u043f\u0435\u0440\u0432\u043e\u0439 \u0431\u0443\u043a\u0432\u0443 &#8220;P&#8221;. \u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u043c Pulp Fiction \u043d\u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445&nbsp; (INSERT) \u0432 \u043b\u044e\u0431\u0443\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u043b\u044c\u043d\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443 \u0438\u0437 \u0411\u0414 \u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440. \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u043d\u044b\u0435 \u043d\u043e\u0432\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e\u0434 \u043d\u043e\u043c\u0435\u0440\u043e\u043c 8, Ilja Vorontsov, 1985-02-02 \u041d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 \u017eanr \u043f\u043e \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u043c\u0443 id. \u041f\u043e \u0434\u0430\u043d\u043d\u043e\u043c\u0443 \u0437\u0430\u043f\u0440\u043e\u0441\u0443 zandriD = 10,Continue reading \"SQL \u2013 Routines\"","og_url":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/","og_site_name":"\/ &Otilde;pimapp \/ Portfoolio","article_modified_time":"2024-03-28T13:39:04+00:00","og_image":[{"url":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-1.png?w=840","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/","url":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/","name":"SQL \u2013 Routines - \/ &Otilde;pimapp \/ Portfoolio","isPartOf":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/#website"},"primaryImageOfPage":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/#primaryimage"},"image":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/#primaryimage"},"thumbnailUrl":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-1.png?w=840","datePublished":"2024-03-02T23:24:39+00:00","dateModified":"2024-03-28T13:39:04+00:00","breadcrumb":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/#primaryimage","url":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-1.png?w=840","contentUrl":"https:\/\/portfooandreei.files.wordpress.com\/2024\/03\/image-1.png?w=840"},{"@type":"BreadcrumbList","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/sql-routines\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/andreitupits23.thkit.ee\/WP\/"},{"@type":"ListItem","position":2,"name":"SQL \u2013 Routines"}]},{"@type":"WebSite","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/#website","url":"https:\/\/andreitupits23.thkit.ee\/WP\/","name":"\/ &Otilde;pimapp \/ Portfoolio","description":"Welcome to my WP page.","publisher":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/andreitupits23.thkit.ee\/WP\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/#organization","name":"\/ &Otilde;pimapp \/ Portfoolio","url":"https:\/\/andreitupits23.thkit.ee\/WP\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/andreitupits23.thkit.ee\/WP\/#\/schema\/logo\/image\/","url":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-content\/uploads\/2024\/03\/cropped-logo.png","contentUrl":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-content\/uploads\/2024\/03\/cropped-logo.png","width":240,"height":240,"caption":"\/ &Otilde;pimapp \/ Portfoolio"},"image":{"@id":"https:\/\/andreitupits23.thkit.ee\/WP\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-json\/wp\/v2\/comments?post=517"}],"version-history":[{"count":1,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/517\/revisions"}],"predecessor-version":[{"id":614,"href":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/517\/revisions\/614"}],"wp:attachment":[{"href":"https:\/\/andreitupits23.thkit.ee\/WP\/wp-json\/wp\/v2\/media?parent=517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}