Mysql导出数据字典

 

• Mysql数据库导出数据字典：

SELECT
	TABLE_SCHEMA as '数据库名称',
	TABLE_NAME as '表字段名',
	COLUMN_NAME as '列字段名',
	COLUMN_TYPE as '列字段类型',
	COLUMN_KEY as '字段约束类型',
	EXTRA as '字段自增',
	IS_NULLABLE as '是否为空',
	COLUMN_COMMENT as '字段说明'
FROM
	information_schema. COLUMNS
WHERE
	TABLE_SCHEMA = 'database_name';

• Mysql查询某列名(column_name)所在的数据库表名(table_name)

SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'column_name';

• Maven命令搭建Web项目

mvn archetype:generate -DgroupId=com.luna.common -DartifactId=common -DarchetypeArtifactId=maven-archetype-webapp -DinteractivMode=false

• Maven命令搭建Java项目

mvn archetype:generate -DgroupId=cn.luna.app -DartifactId=my-app -DarchetypeArtifactId=maven-archetype-quickstart -DinteractiveMode=false