- 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