{"id":794,"date":"2025-02-20T08:34:50","date_gmt":"2025-02-20T08:34:50","guid":{"rendered":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/?page_id=794"},"modified":"2025-03-25T13:31:01","modified_gmt":"2025-03-25T10:31:01","slug":"kinoteatr","status":"publish","type":"page","link":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/","title":{"rendered":"SQL. Stored procedures. Cinema"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li><strong>Global<\/strong><\/li>\n\n\n\n<li><strong>AB<\/strong><\/li>\n\n\n\n<li><strong>Tabel<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-13-1024x438.png\" alt=\"\" class=\"wp-image-811\" \/><\/figure>\n\n\n\n<p><strong>\u041f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c, \u0435\u0441\u043b\u0438 \u0442\u0430\u043c = &#8216;config&#8217;, \u043f\u043e\u043c\u0435\u043d\u044f\u0442\u044c \u043d\u0430 &#8216;cookie&#8217;:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-14.png\" alt=\"\" class=\"wp-image-813\" \/><\/figure>\n\n\n\n<p><strong>MySQL \u2014&gt; \u0422\u0430\u0431\u043b\u0438\u0446\u044b \u2014&gt; user<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-15-1024x255.png\" alt=\"\" class=\"wp-image-814\" \/><\/figure>\n\n\n\n<p><strong>\u0421\u0435\u0440\u0432\u0435\u0440: 127.0.0.1 \u2014&gt; \u0423\u0447\u0451\u0442\u043d\u044b\u0435 \u0437\u0430\u043f\u0438\u0441\u0438  \u2014&gt; \u0421\u043e\u0437\u0434\u0430\u0442\u044c \u043d\u043e\u0432\u0443\u044e \u0443\u0447\u0451\u0442\u043d\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c <\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-16-1024x266.png\" alt=\"\" class=\"wp-image-815\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-17-1024x628.png\" alt=\"\" class=\"wp-image-816\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-18-1024x693.png\" alt=\"\" class=\"wp-image-817\" \/><\/figure>\n\n\n\n<p><strong>\u0417\u0430\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u0438 \u043d\u0430\u0436\u0430\u0442\u044c \u0412\u041f\u0415\u0420\u0401\u0414<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-20-1024x281.png\" alt=\"\" class=\"wp-image-819\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-6-1024x674-1.png\" alt=\"\" class=\"wp-image-820\" \/><\/figure>\n\n\n\n<p><strong>\u0423\u0447\u0451\u0442\u043d\u0430\u044f \u0437\u0430\u043f\u0438\u0441\u044c \u2014&gt; \u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u2014&gt; \u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438 <\/strong><\/p>\n\n\n\n<p>\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)<\/p>\n\n\n\n<p><code><a href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/set.html\">SET<\/a>&nbsp;@p0='add';&nbsp;<a href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/set.html\">SET<\/a>&nbsp;@p1='keel';&nbsp;<a href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/set.html\">SET<\/a>&nbsp;@p2='test';&nbsp;<a href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/set.html\">SET<\/a>&nbsp;@p3='int';&nbsp;<a href=\"http:\/\/localhost\/phpmyadmin\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/call.html\">CALL<\/a>&nbsp;`alter_table`(@p0, @p1, @p2, @p3);<\/code><\/p>\n\n\n\n<p>\u0443\u0434\u0430\u043b\u0438\u0442\u044c \u2014  SET @p0=\u2019drop\u2019; SET @p1=\u2019keel\u2019; SET @p2=\u2019test2\u2032; SET @p3=\u00bb; CALL alter_table(@p0, @p1, @p2, @p3);udali<\/p>\n\n\n\n<h1 class=\"wp-block-heading has-text-align-center\">Kinoteatr<\/h1>\n\n\n\n<p>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043a\u0438\u043d\u043e\u0442\u0435\u0430\u0442\u0440\u0430, \u0432\u043a\u043b\u044e\u0447\u0430\u044f \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0443 \u0442\u0430\u0431\u043b\u0438\u0446 \u0434\u043b\u044f \u0444\u0438\u043b\u044c\u043c\u043e\u0432, \u0436\u0430\u043d\u0440\u043e\u0432 \u0438 \u0441\u0435\u0430\u043d\u0441\u043e\u0432.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-5-1024x550-1.png\" alt=\"\" class=\"wp-image-822\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\">1. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c INSERT \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 rezisoor \u0438\u0437 \u0411\u0414 Kinoteatr:<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-23-1024x359.png\" alt=\"\" class=\"wp-image-840\" \/><\/figure>\n\n\n\n<p>\u0421\u043e\u0437\u0434\u0430\u0451\u043c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0443<strong>&nbsp;lisaRezisoor<\/strong>&nbsp;\u043d\u0430 \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u043d\u043e\u0432\u043e\u0433\u043e \u0440\u0435\u0436\u0438\u0441\u0441\u0451\u0440\u0430 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0443<strong>&nbsp;rezisoor:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-24-1024x523.png\" alt=\"\" class=\"wp-image-841\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-25-1024x131.png\" alt=\"\" class=\"wp-image-842\" \/><\/figure>\n\n\n\n<p>\u0412\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u043c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440y<strong> &#8216;lisaRevizoor&#8217;<\/strong>, \u0434\u043e\u0431\u0430\u0432\u043b\u044f\u0435\u043c \u043d\u043e\u0432\u044b\u0435 \u0434\u0430\u043d\u043d\u044b\u0435 \u0438 \u0432\u0438\u0434\u0438\u043c \u043a\u043e\u043c\u0430\u043d\u0434\u0443 \u0434\u043b\u044f \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u044f:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-26.png\" alt=\"\" class=\"wp-image-843\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-28-1024x459.png\" alt=\"\" class=\"wp-image-845\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">2. \u0423\u0434\u0430\u043b\u044f\u0435\u043c \u0437\u0430\u043f\u0438\u0441\u044c \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 zanr \u043f\u043e \u0432\u0432\u0435\u0434\u0435\u043d\u043d\u043e\u043c\u0443 id:<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-29-1024x311.png\" alt=\"\" class=\"wp-image-846\" \/><\/figure>\n\n\n\n<p>\u0421\u043e\u0437\u0434\u0430\u0451\u043c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0443<strong>&nbsp;zanrdel<\/strong>&nbsp;\u043d\u0430 \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 zanr \u043f\u043e id<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-30.png\" alt=\"\" class=\"wp-image-847\" \/><\/figure>\n\n\n\n<p>\u0412\u044b\u0437\u044b\u0432\u0430\u0435\u043c \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u0443 <strong>zanrdel<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-1024x516.png\" alt=\"\" class=\"wp-image-926\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-1.png\" alt=\"\" class=\"wp-image-927\" \/><\/figure>\n\n\n\n<p>\u041a\u043e\u043c\u0430\u043d\u0434\u0430 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 &#8211; \u0443\u0434\u0430\u043b\u044f\u0435\u0442 \u0437\u0430\u043f\u0438\u0441\u0438 \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u043f\u043e id.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. \u0423\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.<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>\u041f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c, \u0435\u0441\u043b\u0438 \u0442\u0430\u043c = &#8216;config&#8217;, \u043f\u043e\u043c\u0435\u043d\u044f\u0442\u044c \u043d\u0430 &#8216;cookie&#8217;: MySQL \u2014&gt; \u0422\u0430\u0431\u043b\u0438\u0446\u044b \u2014&gt; user \u0421\u0435\u0440\u0432\u0435\u0440: 127.0.0.1 \u2014&gt; \u0423\u0447\u0451\u0442\u043d\u044b\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u2014&gt; \u0421\u043e\u0437\u0434\u0430\u0442\u044c \u043d\u043e\u0432\u0443\u044e \u0443\u0447\u0451\u0442\u043d\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c \u0417\u0430\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u0438 \u043d\u0430\u0436\u0430\u0442\u044c \u0412\u041f\u0415\u0420\u0401\u0414 \u0423\u0447\u0451\u0442\u043d\u0430\u044f \u0437\u0430\u043f\u0438\u0441\u044c \u2014&gt; \u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u2014&gt; \u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438 \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) SET&nbsp;@p0=&#8217;add&#8217;;&nbsp;SET&nbsp;@p1=&#8217;keel&#8217;;&nbsp;SET&nbsp;@p2=&#8217;test&#8217;;&nbsp;SET&nbsp;@p3=&#8217;int&#8217;;&nbsp;CALL&nbsp;`alter_table`(@p0, @p1, @p2, @p3); \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u2014 SET &hellip; <a href=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SQL. Stored procedures. Cinema<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"class_list":["post-794","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL. Stored procedures. Cinema - Portfolio of Iryna Dmytrenko<\/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:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL. Stored procedures. Cinema - Portfolio of Iryna Dmytrenko\" \/>\n<meta property=\"og:description\" content=\"\u041f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c, \u0435\u0441\u043b\u0438 \u0442\u0430\u043c = &#8216;config&#8217;, \u043f\u043e\u043c\u0435\u043d\u044f\u0442\u044c \u043d\u0430 &#8216;cookie&#8217;: MySQL \u2014&gt; \u0422\u0430\u0431\u043b\u0438\u0446\u044b \u2014&gt; user \u0421\u0435\u0440\u0432\u0435\u0440: 127.0.0.1 \u2014&gt; \u0423\u0447\u0451\u0442\u043d\u044b\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u2014&gt; \u0421\u043e\u0437\u0434\u0430\u0442\u044c \u043d\u043e\u0432\u0443\u044e \u0443\u0447\u0451\u0442\u043d\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c \u0417\u0430\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u0438 \u043d\u0430\u0436\u0430\u0442\u044c \u0412\u041f\u0415\u0420\u0401\u0414 \u0423\u0447\u0451\u0442\u043d\u0430\u044f \u0437\u0430\u043f\u0438\u0441\u044c \u2014&gt; \u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u2014&gt; \u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438 \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) SET&nbsp;@p0=&#039;add&#039;;&nbsp;SET&nbsp;@p1=&#039;keel&#039;;&nbsp;SET&nbsp;@p2=&#039;test&#039;;&nbsp;SET&nbsp;@p3=&#039;int&#039;;&nbsp;CALL&nbsp;`alter_table`(@p0, @p1, @p2, @p3); \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u2014 SET &hellip; Continue reading SQL. Stored procedures. Cinema\" \/>\n<meta property=\"og:url\" content=\"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/\" \/>\n<meta property=\"og:site_name\" content=\"Portfolio of Iryna Dmytrenko\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-25T10:31:01+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/kinoteatr\\\/\",\"url\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/kinoteatr\\\/\",\"name\":\"SQL. Stored procedures. Cinema - Portfolio of Iryna Dmytrenko\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/kinoteatr\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/kinoteatr\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-13-1024x438.png\",\"datePublished\":\"2025-02-20T08:34:50+00:00\",\"dateModified\":\"2025-03-25T10:31:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/kinoteatr\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/kinoteatr\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/kinoteatr\\\/#primaryimage\",\"url\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-13-1024x438.png\",\"contentUrl\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-13-1024x438.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/kinoteatr\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL. Stored procedures. Cinema\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Portfolio of Iryna Dmytrenko\",\"description\":\"Junior Software Developer specialty\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/irynadmytrenko24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL. Stored procedures. Cinema - Portfolio of Iryna Dmytrenko","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:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/","og_locale":"en_US","og_type":"article","og_title":"SQL. Stored procedures. Cinema - Portfolio of Iryna Dmytrenko","og_description":"\u041f\u0440\u043e\u0432\u0435\u0440\u0438\u0442\u044c, \u0435\u0441\u043b\u0438 \u0442\u0430\u043c = &#8216;config&#8217;, \u043f\u043e\u043c\u0435\u043d\u044f\u0442\u044c \u043d\u0430 &#8216;cookie&#8217;: MySQL \u2014&gt; \u0422\u0430\u0431\u043b\u0438\u0446\u044b \u2014&gt; user \u0421\u0435\u0440\u0432\u0435\u0440: 127.0.0.1 \u2014&gt; \u0423\u0447\u0451\u0442\u043d\u044b\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u2014&gt; \u0421\u043e\u0437\u0434\u0430\u0442\u044c \u043d\u043e\u0432\u0443\u044e \u0443\u0447\u0451\u0442\u043d\u0443\u044e \u0437\u0430\u043f\u0438\u0441\u044c \u0417\u0430\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u0438 \u043d\u0430\u0436\u0430\u0442\u044c \u0412\u041f\u0415\u0420\u0401\u0414 \u0423\u0447\u0451\u0442\u043d\u0430\u044f \u0437\u0430\u043f\u0438\u0441\u044c \u2014&gt; \u0411\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u2014&gt; \u0420\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438 \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) SET&nbsp;@p0='add';&nbsp;SET&nbsp;@p1='keel';&nbsp;SET&nbsp;@p2='test';&nbsp;SET&nbsp;@p3='int';&nbsp;CALL&nbsp;`alter_table`(@p0, @p1, @p2, @p3); \u0443\u0434\u0430\u043b\u0438\u0442\u044c \u2014 SET &hellip; Continue reading SQL. Stored procedures. Cinema","og_url":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/","og_site_name":"Portfolio of Iryna Dmytrenko","article_modified_time":"2025-03-25T10:31:01+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/","url":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/","name":"SQL. Stored procedures. Cinema - Portfolio of Iryna Dmytrenko","isPartOf":{"@id":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/#primaryimage"},"image":{"@id":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/#primaryimage"},"thumbnailUrl":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-13-1024x438.png","datePublished":"2025-02-20T08:34:50+00:00","dateModified":"2025-03-25T10:31:01+00:00","breadcrumb":{"@id":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/#primaryimage","url":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-13-1024x438.png","contentUrl":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/wp-content\/uploads\/2025\/02\/image-13-1024x438.png"},{"@type":"BreadcrumbList","@id":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/kinoteatr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"SQL. Stored procedures. Cinema"}]},{"@type":"WebSite","@id":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/","name":"Portfolio of Iryna Dmytrenko","description":"Junior Software Developer specialty","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=794"}],"version-history":[{"count":1,"href":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/794\/revisions"}],"predecessor-version":[{"id":1215,"href":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/794\/revisions\/1215"}],"wp:attachment":[{"href":"https:\/\/irynadmytrenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}