《Mysql数据库information_schema系统表说明》由会员分享，可在线阅读，更多相关《Mysql数据库information_schema系统表说明（8页珍藏版）》请在金锄头文库上搜索。
1、information_schema数据库表说明:SCHEMATA表：提供了当前mysql实例中所有数据库的信息。是showdatabases的结果取之此表。CAT.JJO&JlWilESCHEMAJJAfffiDEJAl.LT_CHA5JkCrEE_SETDEFA1_ILT_CULLMION_NANESQL_PATH(NULL)information._schtmaat田utf8_gener:J_ci(MIL)(NULL)hisnriTLagerat田ut8_genei：=il_ci(NULL)INULL)hismedicinet田utS_gener：l_ciMl)INULL)mysqlat
2、8utfS_gen.Hi-：J_ciMl)INULL)tEEtat田utf8_gener:l_ciMl)*INULL)Ml)TABLES表：提供了关于数据库中的表的信息（包括视图）。详细表述了某个表属于哪个schema，表类型，表引擎，创建时间等信息。是showtablesfromschemaname的结果取之此表。TABLEECHEMTABLEJfiWrftBLE-E胆ekipeVEEEI吓TftBLE!阳ftVJMWLEKrrHBTALEJKrTHm+）LD訂扎丄EBGTHIJfDI上onnijiTiform.Lloa_EchmA.STATISTICSSTSTiriWZEflNBIttkY
3、inFLZfddCHULL：l2679016?7054|gpjn.；iijif4trn.tLg_wch血在TAI：LESsrsiiriranriEiWM1口PixdCruel)3E450ISTWiCOffllJUL.：!informlE_scb.imia7fiI：LE_D3ffSTfiAniISsrsTzriranriETO10Pix4d(Mi)29W016719256Hull)infomatl乩srsTzriranriEmB10Pix4diWiJ23T2016r-t3G92HUH.)inf4tm4.tL0IL_5Ch.imi7BIWEK3STSiiJiran10thmudciWila02ai
4、4HffT6TL0fiE5OfULUinfcidtlppliu=LiDudwtuLsBXSE丁ABLEZLnrioDB30CMipuctlja16E8-40UlJUJhi.anudiHu电E：XSETAELEZnrmDB10Etfhpacllja36ZS-1ljffllJUL.：!IlLQmdjCLIUIcuicL的adsdeti.LBJlSETAELEZnrmDB10Ecfhp-acilja16ZS-10tSUlL)bLLnedjcLuecb.tdf7LtnranQnwffllJlL)IMLiIW1I(S1J1L)iUULLJiWLL.ItlfULLJbiLe亡d-uweiBASETABLE
5、Cmp-act5q63S40OdWbLLsmtdocLJiedcpartinen.tBK5ETABLEInnoDB10Crfljact:mew16304口OfULUbLLsmedocLJiedmiatDreLJiTwitoryBK5ETABLEInnoDBCmjact11Q1630*0QiUlljLlxn*iacluedrupkarlbIIRASETABLEItmaDHQCE-rapbe!0a曲细I0QiUlljh.LSflwdiCLnd血tDK4LiillhiAllsEASETABLEIclTiDBOCijflpp亡I00362840UlJUJhisnwdj吧BXSETABLEInrioDB
6、JOCMvpaci2BL92IE溯ljqpjn.；ihLSnwdjcLIMTABUIdtidDB10Cuvpaci354fii托潔0CH1JU-)bLL91fiiZilL4QHplQFP喀TDi电Pi.4HranaiULL)ffllJlX)(BULL：iiHVLLjiBULLjimnijdnjiL)b.Lsnedj_Ln.efgctiwatalleBASE7AB1ZZnrmDH10Ccfhp-act汨S640IIICOLUMNS表：提供了表中的列信息。详细表述了某张表的所有列以及每个列的信息。是showcolumnsfromschemaname.tablename的结果取之此表。STATIST
7、ICS表：提供了关于表索引的信息。是showindexfromschemaname.tablename的结果取之此表。USER_PRIVILEGES（用户权限）表：给出了关于全程权限的信息。该信息源自mysql.user授权表。是非标准表。GRA2ITEETABLECATAIJOG-FMVILEG-ETYFEISG-RkHTABLE匸do七飞localhwt|(HULL)SELECTYES*foot/localhcsi(HULL)INSERTIESJrootJ迪localho5tJ(WLL)UPDATEYESJrootJ迪localho5tJ(WLL)DELETEYESJrootJJlocal
8、hoEtJ(NULL)CREATEYESJrootJJlocalhotJtNULL)BEOFTESJroof1localhoEf1(NULL)SELOALYESJrJlaialhis+J(MLL)SHUTBOWNTESJfhot/JlocalhcstCMULL)PROCESSYESroot?loceltLOE+CNULL)FILEYES*foot/localhcsi(HULL)EEFEKE1TCESYEE*fcicii?；localhost(HULL)INTEKYESJrootJ迪localho5tJ(WLL)ALTERYESJrootJJlocalhostJ(Mll)SHOWDATABASE
9、STESJrootJ宜localhoEtJCnull)SUFEE.YESJroof1JlocalhoEf1CNULL)CREATETEHFORAETTX6LZSTESJrftof1JlocalhcElJOIULL)LOCKTABLESYESJrJlaialhis+J(HULL)EXECUTETESr!：Of1OC：=l1?li：ietCnull)EEPLJCATIO1TSLAVEYESJfoot/localhoEF(HULL):REF口CATIQirCUEHTYES*foot/localhcs-f(HULL)CREATEVIEWYESJrootJ釘localhostJ(WLL)SHOWVIEW
10、畑JrootJ&localho5tJ(WLL)CREATEROUTTlffiYESJrootJlocalhostJ(Mll)ALTERROUTINEYESSCHEMA_PRIVILEGES（方案权限）表：给出了关于方案（数据库）权限的信息。该信息来自mysql.db授权表。是非标准表。GRAJiTEETABLE丄丸TAIDGTABLESCHEMkFEIVILEGETnE巧GRANTABLE*muTABLE_PRIVILEGES（表权限）表：给出了关于表权限的信息。该信息源自mysql.tables_priv授权表。是非标准表。GRkKTEETAILECkTALCi?TAELESCHEHAtae
11、leeFEIVILE(5ETYrE*1(NULL)COLUMN_PRIVILEGES（列权限）表：给出了关于列权限的信息。该信息源自mysql.columnspriv授权表。是非标准表。(rWHEE7ABLECMALOCjTABLE5CHBflATADIJEBMIEC0LUNNWEF肛门LZGETTTEISAJfTiMiLE*1muCHARACTER_SETS（字符集）表：提供了mysql实例可用字符集的信息。是SHOWCHARACTERSET结果集取之此表。CHmCTERSETNOEDEFAULTCOLLATEEDESCRIPTIOWMASLE1Tbig5_chint：Efj_eiI；ig5TriditiijrL：alChitlhSmZd.ec8dec8_swediHECAez七Em-ope：=ltl1cp650cpuuLLgener；il_ciIOSfestEuropean1hp8hp8_rLglish_ciIffWestEuropean.1ko18rkolcrgeELer：al_c1XOI8-RRelci：imFjissi:in1Ltinl_s,iBi,
