Obsidian/Recognition/Programing/MariaDB/테이블 코멘트 작성.md

8 lines
278 B
Markdown

```sql
select concat('COMMENT ON TABLE ', replace(tbl_user, 'TS_', 'U'), '.', tbl_id, ' IS ''', tbl_nm, ' (',tbl_desc,')'';') as tbl_com
from tbl_info
group by concat('COMMENT ON TABLE ', replace(tbl_user, 'TS_', 'U'), '.', tbl_id, ' IS ''', tbl_nm, ' (',tbl_desc,')'';')
```