1 2 3 4 5 6 7
| 2022-03-05 21:14:37.390 INFO 6900 --- [ main] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} inited #score, student tables = [{TABLE_CATALOG=def, TABLE_COMMENT=, TABLE_NAME=score, TABLE_SCHEMA=mydata, ENGINE=InnoDB, TABLE_TYPE=BASE TABLE, TABLE_ROWS=18, AVG_ROW_LENGTH=910, DATA_LENGTH=16384, DATA_FREE=0, INDEX_LENGTH=0, ROW_FORMAT=Dynamic, VERSION=10, CREATE_OPTIONS=, CREATE_TIME=2022-02-22T18:54:40, MAX_DATA_LENGTH=0, TABLE_COLLATION=utf8mb4_general_ci}, {TABLE_CATALOG=def, TABLE_COMMENT=, TABLE_NAME=student, TABLE_SCHEMA=mydata, ENGINE=InnoDB, TABLE_TYPE=BASE TABLE, TABLE_ROWS=8, AVG_ROW_LENGTH=2048, DATA_LENGTH=16384, DATA_FREE=0, INDEX_LENGTH=0, ROW_FORMAT=Dynamic, VERSION=10, CREATE_OPTIONS=, CREATE_TIME=2022-02-22T18:46:32, MAX_DATA_LENGTH=0, TABLE_COLLATION=utf8mb4_general_ci}] #score字段 tableColumns = [{TABLE_CATALOG=def, IS_NULLABLE=NO, TABLE_NAME=score, TABLE_SCHEMA=mydata, EXTRA=, COLUMN_NAME=s_id, COLUMN_KEY=PRI, CHARACTER_OCTET_LENGTH=80, PRIVILEGES=select,insert,update,references, COLUMN_COMMENT=成绩id, COLLATION_NAME=utf8mb4_general_ci, COLUMN_TYPE=varchar(20), GENERATION_EXPRESSION=, ORDINAL_POSITION=1, CHARACTER_MAXIMUM_LENGTH=20, DATA_TYPE=varchar, CHARACTER_SET_NAME=utf8mb4}, {TABLE_CATALOG=def, IS_NULLABLE=NO, TABLE_NAME=score, TABLE_SCHEMA=mydata, EXTRA=, COLUMN_NAME=c_id, COLUMN_KEY=PRI, CHARACTER_OCTET_LENGTH=80, PRIVILEGES=select,insert,update,references, COLUMN_COMMENT=课程id, COLLATION_NAME=utf8mb4_general_ci, COLUMN_TYPE=varchar(20), GENERATION_EXPRESSION=, ORDINAL_POSITION=2, CHARACTER_MAXIMUM_LENGTH=20, DATA_TYPE=varchar, CHARACTER_SET_NAME=utf8mb4}, {TABLE_CATALOG=def, IS_NULLABLE=YES, TABLE_NAME=score, TABLE_SCHEMA=mydata, EXTRA=, COLUMN_NAME=s_score, COLUMN_KEY=, NUMERIC_PRECISION=10, PRIVILEGES=select,insert,update,references, COLUMN_COMMENT=成绩分数, NUMERIC_SCALE=0, COLUMN_TYPE=int(3), GENERATION_EXPRESSION=, ORDINAL_POSITION=3, DATA_TYPE=int}] #student字段 tableColumns = [{TABLE_CATALOG=def, IS_NULLABLE=NO, TABLE_NAME=student, TABLE_SCHEMA=mydata, EXTRA=, COLUMN_NAME=s_id, COLUMN_KEY=PRI, CHARACTER_OCTET_LENGTH=80, PRIVILEGES=select,insert,update,references, COLUMN_COMMENT=学生id, COLLATION_NAME=utf8mb4_general_ci, COLUMN_TYPE=varchar(20), GENERATION_EXPRESSION=, ORDINAL_POSITION=1, CHARACTER_MAXIMUM_LENGTH=20, DATA_TYPE=varchar, CHARACTER_SET_NAME=utf8mb4}, {TABLE_CATALOG=def, IS_NULLABLE=YES, TABLE_NAME=student, TABLE_SCHEMA=mydata, EXTRA=, COLUMN_NAME=s_name, COLUMN_KEY=, CHARACTER_OCTET_LENGTH=80, PRIVILEGES=select,insert,update,references, COLUMN_COMMENT=学生姓名, COLLATION_NAME=utf8mb4_general_ci, COLUMN_TYPE=varchar(20), GENERATION_EXPRESSION=, ORDINAL_POSITION=2, CHARACTER_MAXIMUM_LENGTH=20, DATA_TYPE=varchar, CHARACTER_SET_NAME=utf8mb4}, {TABLE_CATALOG=def, IS_NULLABLE=YES, TABLE_NAME=student, TABLE_SCHEMA=mydata, EXTRA=, COLUMN_NAME=s_birth, COLUMN_KEY=, CHARACTER_OCTET_LENGTH=80, PRIVILEGES=select,insert,update,references, COLUMN_COMMENT=学生生日, COLLATION_NAME=utf8mb4_general_ci, COLUMN_TYPE=varchar(20), GENERATION_EXPRESSION=, ORDINAL_POSITION=3, CHARACTER_MAXIMUM_LENGTH=20, DATA_TYPE=varchar, CHARACTER_SET_NAME=utf8mb4}, {TABLE_CATALOG=def, IS_NULLABLE=YES, TABLE_NAME=student, TABLE_SCHEMA=mydata, EXTRA=, COLUMN_NAME=s_sex, COLUMN_KEY=, CHARACTER_OCTET_LENGTH=40, PRIVILEGES=select,insert,update,references, COLUMN_COMMENT=学生性别, COLLATION_NAME=utf8mb4_general_ci, COLUMN_TYPE=varchar(10), GENERATION_EXPRESSION=, ORDINAL_POSITION=4, CHARACTER_MAXIMUM_LENGTH=10, DATA_TYPE=varchar, CHARACTER_SET_NAME=utf8mb4}]
|