{"id":307,"date":"2024-02-24T22:00:44","date_gmt":"2024-02-24T22:00:44","guid":{"rendered":"https:\/\/blog.hostinger.io\/uk\/support\/2024\/02\/24\/1583521-%d1%89%d0%be-%d1%82%d0%b0%d0%ba%d0%b5-information_schema-%d0%b1%d0%b0%d0%b7%d0%b8-%d0%b4%d0%b0%d0%bd%d0%b8%d1%85-%d1%83-phpmyadmin\/"},"modified":"2025-08-26T18:51:31","modified_gmt":"2025-08-26T18:51:31","slug":"1583521-%d1%89%d0%be-%d1%82%d0%b0%d0%ba%d0%b5-information_schema-%d0%b1%d0%b0%d0%b7%d0%b8-%d0%b4%d0%b0%d0%bd%d0%b8%d1%85-%d1%83-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/ua\/support\/1583521-%d1%89%d0%be-%d1%82%d0%b0%d0%ba%d0%b5-information_schema-%d0%b1%d0%b0%d0%b7%d0%b8-%d0%b4%d0%b0%d0%bd%d0%b8%d1%85-%d1%83-phpmyadmin\/","title":{"rendered":"\u0429\u043e \u0422\u0430\u043a\u0435 Information_Schema \u0411\u0430\u0437\u0438 \u0414\u0430\u043d\u0438\u0445 \u0443 PhpMyAdmin?"},"content":{"rendered":"

Щоразу, коли Ви переходите до будь-якої з Ваших баз даних через phpMyAdmin<\/a><\/b>, Ви бачите базу даних з назвою information_schema<\/b>:<\/p>

\n<\/p>

\"The<\/div>

information_schema<\/b> – це системна база даних, створена за замовчуванням<\/b>, яка зберігає деталі про базу даних, такі як структура бази даних, метадані та привілеї користувачів. <\/p>

\n<\/p>

Розробники можуть використовувати інформацію, що міститься в цій базі даних, щоб мати уявлення про схему бази даних, зрозуміти взаємозв’язки між таблицями, а також оптимізувати запити та продуктивність бази даних.<\/p>

\n

Через важливість збереження її цілісності, базу даних information_schema<\/b> не можна редагувати або видаляти<\/b>💡<\/p>\n<\/div>

\n<\/p>\n","protected":false},"excerpt":{"rendered":"

\u0412\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u0430\u043d\u043d\u044f information_schema \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0456\u043d\u043d\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u0438\u0445<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[216],"tags":[],"class_list":["post-307","post","type-post","status-publish","format-standard","hentry","category-phpmyadmin"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/1583521-what-is-the-database-information_schema-on-phpmyadmin\/","default":1},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/1583521-quel-est-l-information_schema-de-la-base-de-donnees-que-je-peux-voir-dans-mon-phpmyadmin-en-ai-je-besoin\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/1583521-apa-itu-database-information_schema-di-phpmyadmin-apakah-saya-membutuhkannya-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/1583521-o-que-e-o-banco-de-dados-information_schema-do-meu-phpmyadmin-e-para-que-preciso-dele-no-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/1583521---information_schema----phpmyadmin\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/posts\/307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/comments?post=307"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/posts\/307\/revisions"}],"predecessor-version":[{"id":652,"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/posts\/307\/revisions\/652"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/media?parent=307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/categories?post=307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/ua\/support\/wp-json\/wp\/v2\/tags?post=307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}