search

Home >Database >Mysql Tutorial >mysql 常用sql操作语句_MySQL

mysql 常用sql操作语句_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:16:18966browse

获取数据库里所有表

SELECT TABLE_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='数据库名'

获取表里所有字段

select column_name from information_schema.columns where table_schema='数据库名' and 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：Mariadb源码编译过程_MySQLNext article：MySQL查询时强制区分大小写_MySQL

Related articles

See more