{"id":364,"date":"2021-10-05T23:14:54","date_gmt":"2021-10-05T23:14:54","guid":{"rendered":"http:\/\/jplatz.com.br\/syntax\/?p=364"},"modified":"2021-11-12T23:56:15","modified_gmt":"2021-11-12T23:56:15","slug":"mysql-show-e-describe-para-inspecionar-informacoes-de-tabelas","status":"publish","type":"post","link":"https:\/\/jplatz.com.br\/syntax\/2021\/10\/05\/mysql-show-e-describe-para-inspecionar-informacoes-de-tabelas\/","title":{"rendered":"MySQL Show e Describe para inspecionar informa\u00e7\u00f5es de tabelas"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\"># present very basic information, but not custom indexes\nDESCRIBE payments;\n\n# basically the same as describe\nSHOW COLUMNS FROM <meta charset=\"utf-8\">payments;\nSHOW COLUMNS FROM production.<meta charset=\"utf-8\">payments;\nSHOW COLUMNS FROM <meta charset=\"utf-8\">payments IN production;\n\n# a more detailed information\nSHOW FULL COLUMNS FROM payments;\n\n# wanna see custom indexes?\nSHOW INDEX FROM payments;\nSHOW INDEX FROM payments FROM production;\nSHOW INDEX FROM production.payments;<\/pre>\n\n\n\n<p>Sempre que eu quero inspecionar os detalhes de informa\u00e7\u00f5es de uma tabela no <strong>MySQL<\/strong> eu somente consigo me lembrar do comando <strong>DESCRIBE<\/strong>, ou nem isso!<\/p>\n\n\n\n<p>O Fato \u00e9 que o <strong>MySQL<\/strong> fornece alguns recursos b\u00e1sicos mas muito eficientes para obter estas informa\u00e7\u00f5es de forma simples e r\u00e1pida.<\/p>\n\n\n\n<p>Se voc\u00ea \u00e9 developer certamente vai precisar de alguns destes recursos listados a\u00ed&#8230;<\/p>\n\n\n\n<p>Os Databases Scientists e Database Administrators podem querer recorrer a recursos mais avan\u00e7ados como <strong>SELECT<\/strong> sobre as tabelas de <strong>SCHEMAS<\/strong>, mas isso \u00e9 assunto para outro artigo. <\/p>\n\n\n\n<p>Happy SQL!<\/p>\n","protected":false},"excerpt":{"rendered":"<p># present very basic information, but not custom indexes DESCRIBE payments; # basically the same as describe SHOW COLUMNS FROM payments; SHOW COLUMNS FROM production.payments; SHOW COLUMNS FROM payments IN production; # a more detailed information SHOW FULL COLUMNS FROM payments; # wanna see custom indexes? SHOW INDEX FROM payments; SHOW INDEX FROM payments FROM [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,24,23],"tags":[170,171,167,168,169],"class_list":["post-364","post","type-post","status-publish","format-standard","hentry","category-database","category-mariadb","category-mysql","tag-columns","tag-indexes","tag-schema","tag-schema-information","tag-table-information"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/posts\/364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/comments?post=364"}],"version-history":[{"count":3,"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/posts\/364\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/posts\/364\/revisions\/370"}],"wp:attachment":[{"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/media?parent=364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/categories?post=364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jplatz.com.br\/syntax\/wp-json\/wp\/v2\/tags?post=364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}