{"id":2271,"date":"2013-07-12T15:28:25","date_gmt":"2013-07-12T07:28:25","guid":{"rendered":"http:\/\/rmohan.com\/?p=2271"},"modified":"2013-07-12T15:28:42","modified_gmt":"2013-07-12T07:28:42","slug":"mysql-show","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=2271","title":{"rendered":"Mysql show"},"content":{"rendered":"<div>mysqlshow is another way to check the database details table and column information, let&#8217;s check some of the basic commands<\/div>\n<div><\/div>\n<p>shows available databases<br \/>\n# mysqlshow -pmysql<\/p>\n<p>Display all tables in a DB<br \/>\n# mysqlshow -pmysql databasename<\/p>\n<p>Display tables along with number of columns in a database<br \/>\n# mysqlshow -v -pmysql databasename<\/p>\n<p>Display columns and Rows also<br \/>\n# mysqlshow -v -v -pmysql databasename<\/p>\n<div>Display column name along with column information for table in database<\/div>\n<p># mysqlshow -pmysql databasename tablename<\/p>\n<p>it displays information about wid column from tablename table.<br \/>\n#\u00a0mysqlshow -pmysql dbname tablename wid<\/p>\n<p>Show all metadata information about a table.<br \/>\n# mysqlshow -i -pmysql dbname tablename<\/p>\n<p>Display both indexes and columns of a table. Please note that the indexes are listed at the bottom of the display after the column information.<br \/>\n# mysqlshow -k -pmysql dbname tablename<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysqlshow is another way to check the database details table and column information, let&#8217;s check some of the basic commands <\/p>\n<p>shows available databases # mysqlshow -pmysql<\/p>\n<p>Display all tables in a DB # mysqlshow -pmysql databasename<\/p>\n<p>Display tables along with number of columns in a database # mysqlshow -v -pmysql databasename<\/p>\n<p>Display columns and Rows [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2271"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2271"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2271\/revisions"}],"predecessor-version":[{"id":2273,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2271\/revisions\/2273"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}