{"id":42,"date":"2010-03-10T22:01:56","date_gmt":"2010-03-11T03:01:56","guid":{"rendered":"http:\/\/www.richard-bravo.net\/wb\/?p=42"},"modified":"2010-03-10T22:01:56","modified_gmt":"2010-03-11T03:01:56","slug":"ver-todas-las-tablas-de-una-base-en-mysql","status":"publish","type":"post","link":"https:\/\/richard-bravo.net\/wb\/ver-todas-las-tablas-de-una-base-en-mysql\/","title":{"rendered":"Ver todas las tablas de una base en mysql"},"content":{"rendered":"<figure id=\"attachment_43\" aria-describedby=\"caption-attachment-43\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/www.richard-bravo.net\/wb\/wp-content\/uploads\/2010\/03\/Logo-mysql.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-43\" title=\"mysql\" src=\"http:\/\/www.richard-bravo.net\/wb\/wp-content\/uploads\/2010\/03\/Logo-mysql-300x218.jpg\" alt=\"mysql\" width=\"300\" height=\"218\" srcset=\"https:\/\/richard-bravo.net\/wb\/wp-content\/uploads\/2010\/03\/Logo-mysql-300x218.jpg 300w, https:\/\/richard-bravo.net\/wb\/wp-content\/uploads\/2010\/03\/Logo-mysql.jpg 399w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-43\" class=\"wp-caption-text\">mysql<\/figcaption><\/figure>\n<p>Para poder ver todas las tablas que tenemos en una base sql:<\/p>\n<p>Nos tenemos que conectar a nuestro mysql con:<\/p>\n<blockquote><p>mysql -u root -p<\/p><\/blockquote>\n<p>Una vez conectados a mysql tenemos que seleccionar que base de datos queremos usar con:<\/p>\n<blockquote><p>use NombreDeLaBase;<\/p><\/blockquote>\n<p>Finalmente utilizamos el comando SHOW para mostrar todas las tablas que hay dentro de esa base<\/p>\n<blockquote><p>show tables;<\/p><\/blockquote>\n<p>Y listo as\u00ed de sencillos podemos ver todas las tablas que tenemos en nuestra base de datos.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para poder ver todas las tablas que tenemos en una base sql: Nos tenemos que conectar a nuestro mysql con: mysql -u root -p Una vez conectados a mysql tenemos que seleccionar que base de datos queremos usar con: use NombreDeLaBase; Finalmente utilizamos el comando SHOW para mostrar todas las tablas que hay dentro de<\/p>\n<p class=\"readmore-p\"><a class=\"readmore\" href=\"https:\/\/richard-bravo.net\/wb\/ver-todas-las-tablas-de-una-base-en-mysql\/\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[14,23],"tags":[15,61],"class_list":["post-42","post","type-post","status-publish","format-standard","hentry","category-herramientas","category-mysql","tag-herramienta","tag-mysql"],"_links":{"self":[{"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/posts\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":3,"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"predecessor-version":[{"id":46,"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/posts\/42\/revisions\/46"}],"wp:attachment":[{"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/richard-bravo.net\/wb\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}