{"id":120,"date":"2025-02-19T14:45:15","date_gmt":"2025-02-19T05:45:15","guid":{"rendered":"http:\/\/www.viw.co.kr\/ep\/?p=120"},"modified":"2025-02-19T14:45:15","modified_gmt":"2025-02-19T05:45:15","slug":"mariadb-%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%a0%88%ec%9d%b4%ec%95%84%ec%9b%83-%ec%a1%b0%ed%9a%8c","status":"publish","type":"post","link":"http:\/\/www.viw.co.kr\/ep\/mariadb-%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%a0%88%ec%9d%b4%ec%95%84%ec%9b%83-%ec%a1%b0%ed%9a%8c\/","title":{"rendered":"mariadb \ud14c\uc774\ube14 \ub808\uc774\uc544\uc6c3 \uc870\ud68c"},"content":{"rendered":"\n

SELECT a.TABLE_NAME ‘\ud14c\uc774\ube14\uba85’,
b.ORDINAL_POSITION ‘\uc21c\ubc88’,
b.COLUMN_NAME ‘\ud544\ub4dc\uba85’,
b.COLUMN_COMMENT ‘\ud544\ub4dc\uc124\uba85’,
b.DATA_TYPE ‘DATA TYPE’,
b.COLUMN_TYPE ‘\ub370\uc774\ud130\uae38\uc774’,
b.COLUMN_KEY ‘KEY’,
b.IS_NULLABLE ‘NULL\uac12\uc5ec\ubd80’,
b.EXTRA ‘\uc790\ub3d9\uc5ec\ubd80’,
b.COLUMN_DEFAULT ‘\ub514\ud3f4\ud2b8\uac12’
FROM information_schema.TABLES a
JOIN information_schema.COLUMNS b ON a.TABLE_NAME = b.TABLE_NAME AND a.TABLE_SCHEMA = b.TABLE_SCHEMA
WHERE a.TABLE_SCHEMA = ‘nediq’
AND a.TABLE_NAME like ‘it%’
ORDER BY a.TABLE_NAME, b.ORDINAL_POSITION;<\/p>\n","protected":false},"excerpt":{"rendered":"

SELECT a.TABLE_NAME ‘\ud14c\uc774\ube14\uba85’,b.ORDINAL_POSITION ‘\uc21c\ubc88’,b.COLUMN_NAME ‘\ud544\ub4dc\uba85’,b.COLUMN_COMMENT ‘\ud544\ub4dc\uc124\uba85’,b.DATA_TYPE ‘DATA TYPE’,b.COLUMN_TYPE ‘\ub370\uc774\ud130\uae38\uc774’,b.COLUMN_KEY ‘KEY’,b.IS_NULLABLE ‘NULL\uac12\uc5ec\ubd80’,b.EXTRA ‘\uc790\ub3d9\uc5ec\ubd80’,b.COLUMN_DEFAULT ‘\ub514\ud3f4\ud2b8\uac12’FROM information_schema.TABLES aJOIN information_schema.COLUMNS b ON a.TABLE_NAME = b.TABLE_NAME AND a.TABLE_SCHEMA = b.TABLE_SCHEMAWHERE a.TABLE_SCHEMA = ‘nediq’AND a.TABLE_NAME like ‘it%’ORDER BY a.TABLE_NAME, b.ORDINAL_POSITION;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-120","post","type-post","status-publish","format-standard","hentry","category-1","no-post-thumbnail"],"_links":{"self":[{"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/posts\/120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":1,"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"predecessor-version":[{"id":121,"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/posts\/120\/revisions\/121"}],"wp:attachment":[{"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.viw.co.kr\/ep\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}