数据库字段导出到论文表格中

SELECT
	COLUMN_NAME as 字段名称,
	COLUMN_TYPE as 数据类型,
	 CHARACTER_MAXIMUM_LENGTH 长度,
	COLUMN_COMMENT as 备注,
	if(COLUMN_KEY='PRI','Y','N') as 主键,
	 IS_NULLABLE 是否为空
FROM
	INFORMATION_SCHEMA. COLUMNS
WHERE
	table_schema = '数据库名'
AND 
	table_name = '表名'

得到数据

 复制到正文中即可