altertabletestrenametest1;--修改表名mysql查询表所有字段的属性和注释select*frominformation_schema.columnswheretable_name='表名'mysql获取表的所有字段信息SELECTcolumn_namecolumnName,data_typedataType,column_commentcolumnComment,column_keycolumnKey,extraFROMinformation_schema.COLUMNSWHEREtable_name='sys_user'ANDtable_schema=(SELECTDATABASE())ORDERBYordinal_position