Home >Database >Mysql Tutorial >mysql 查看表结构_MySQL
mysql 查看表结构_MySQL
- WBOYOriginal
- 2016-06-01 13:28:18995browse
bitsCN.com
desc tablename;
show columns from tablename;
describe tablename;
show create table tablename;
use information_schema;
select * from columns where table_name='tablename';
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：mysql删除子查询中的记录语句_MySQLNext article：MySQL备份与恢复之真实环境使用冷备_MySQL