mysql数据表所有字段，如何打印mysql数据库中所有表的所有
字段？
I'm trying to learn the structure of a mysql database I'm not familiar with. It's been years since I used mysql.
I'm looking for a way to print all the fields for all the tables in this database. At the moment, I'm using
Show Fields from
However, this slow and clunky. Is there a faster way?
解决⽅案
To see all tables of a specific database (like mydb), do this:
USE mydb
spring全部注解SHOW TABLES;
To see all fields, indexes, storage engine, table options, partition layout able, do this:
USE mydb
SHOW CREATE TABLE tblname\G
mysqlschema作用To see all tables in all databases in bulk, here is a script:
MYSQL_USER=root
MYSQL_PASS=rootpassword关于weight的短语
MYSQL_CONN="-u${MYSQL} -p${MYSQL_PASS}"
MYSQLDUMP_OPTIONS="--routines --triggers --no-data --all-databases"
mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} > MySQLSchema.sql
less MySQLSchema.sql
If you want to see a specific database (like mydb), do this:
lambda原理MYSQL_USER=root
MYSQL_PASS=rootpassword
数据库系统管理工程师考哪些
MYSQL_CONN="-u${MYSQL} -p${MYSQL_PASS}"
DBTOSHOW=mydb
MYSQLDUMP_OPTIONS="--routines --triggers --no-data --databases ${DBTOSHOW}"
mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} > MySQLSchema.sql
less MySQLSchema.sql
eva绫波丽This should be the quickest way because accessing the information_schema database can be somewhat slow if there are a lot of busy InnoDB tables.
Give it a Try

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。