mysql, mariadb 테이블 구조(상세 정보) 확인 명령

mysql, mariadb 에서 테이블 상세 정보를 확인해야 할 때 사용하는 명령어 간락한 테이블 정보를 보여준다. desc 테이블명;  MariaDB [dbname]> DESC account; +——————-+————-+——+—–+———+—————-+ | Field                 | Type         | Null   | Key | Default | Extra              | +——————-+————-+——+—–+———+—————-+ | account_no        | int(11)        | NO   | PRI | NULL    | auto_increment | | year                 | int(11)        | … Read more

This website stores cookies on your computer. These cookies are used to provide a more personalized experience and to track your whereabouts around our website in compliance with the European General Data Protection Regulation. If you decide to to opt-out of any future tracking, a cookie will be setup in your browser to remember this choice for one year.

Accept or Deny