Home >Database >Mysql Tutorial >MySQL Table Information_MySQL
MySQL Table Information_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:17:26830browse
show tables; --显示该数据库里的所有表
show columns from 表名; --显示表字段
use information_schema
select * from columns where table_name='表名'; --显示表字段
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Linux下MySQL备份以及crontab定时备份_MySQLNext article：MacOS安装卸载MySQL教程_MySQL