{"id":92,"date":"2020-06-09T10:19:24","date_gmt":"2020-06-09T02:19:24","guid":{"rendered":"http:\/\/www.gbase8.cn\/?p=92"},"modified":"2020-09-08T10:29:10","modified_gmt":"2020-09-08T02:29:10","slug":"gbase8a-%e9%9b%86%e7%be%a4%e6%9f%a5%e7%9c%8b%e8%a1%a8%e9%87%8c%e6%9c%89%e5%93%aa%e4%ba%9b%e5%88%97%ef%bc%8c%e6%9f%90%e4%b8%aa%e5%88%97%e6%98%af%e5%90%a6%e5%ad%98%e5%9c%a8","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/92","title":{"rendered":"Nangong Tongyong GBase8a cluster: how to view columns in a table and check if a specific column exists."},"content":{"rendered":"<p>GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u63d0\u4f9b\u4e86\u5143\u6570\u636e\u8868information_shema.columns,\u83b7\u5f97\u6307\u5b9a\u8868\u7684\u5217\u5b9a\u4e49\u3002\u4e5f\u53ef\u4ee5\u901a\u8fc7desc \u65b9\u5f0f\u67e5\u770b\u5217\u5b9a\u4e49\u3002<\/p>\n\n\n\n<p>\u901a\u8fc7desc<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"238\" src=\"http:\/\/www.gbase8.cn\/wp-content\/uploads\/2020\/06\/image-35.png\" alt=\"\" class=\"wp-image-93\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>\u901a\u8fc7\u5143\u6570\u636e\u8868<\/li><\/ul>\n\n\n\n<p>select column_name,ordinal_position,is_nullable,data_type,character_maximum_length,numeric_precision from information_schema.columns where table_schema='testdb' and table_name='t'<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u5176\u5b83\u5143\u6570\u636e\u6709\u5173\uff0c\u8bf7\u53c2\u8003<\/p>\n\n\n\n<p><a href=\"http:\/\/www.gbase8.cn\/en\/?p=88\">GBase8a \u96c6\u7fa4\u67e5\u770b\u5e93\u91cc\u6709\u54ea\u4e9b\u89c6\u56fe<\/a><\/p>\n\n\n\n<p><a href=\"http:\/\/www.gbase8.cn\/en\/?p=79\">GBase8a \u96c6\u7fa4\u67e5\u770b\u5e93\u91cc\u6709\u54ea\u4e9b\u8868\uff0c\u6216\u67d0\u5f20\u8868\u662f\u5426\u5b58\u5728<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>\u5357\u5927\u901a\u7528GBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u63d0\u4f9b\u4e86\u5143\u6570\u636e\u8868information_shema.columns,\u83b7\u5f97\u6307\u5b9a\u8868\u7684\u5217\u5b9a\u4e49\u3002\u4e5f\u53ef\u4ee5\u901a\u8fc7desc \u65b9\u5f0f\u67e5\u770b\u5217\u5b9a\u4e49\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[69],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-69"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":2,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":1058,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/92\/revisions\/1058"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}