MySQL CREATE table specifies the character type associated with the storage engine

DROP TABLE IF EXISTSApilog;/*==============================================================*//*Table:apilog*//*==============================================================*/CREATE TABLEApilog (IdVARCHAR( +), SystemNameVARCHAR( -) COMMENT'System name', SystemcodeVARCHAR( -) COMMENT'system Code', IndentifyVARCHAR( -) COMMENT'identification (various unique IDs such as: UserId, orderId, etc.)', ModuleIDVARCHAR( -) COMMENT'Module ID', ServiceNameVARCHAR( -) COMMENT'Interface Name', ClientIPVARCHAR( the) COMMENT'Client IP', ClientTypeINTCOMMENT'client Type android,20 IOS, IE, firefox,32 Opera, Safari, Chrome, max Service (System services)', RequestTypeINTCOMMENT'Request Type: 0 get,1 post,2 put,3 DELETE', ResponseStatusINTCOMMENT'Response Status 0 Success 1 failed', ResponseTimeINTCOMMENT'Response Duration (ms)', InputparamVARCHAR( -) COMMENT'Interface Entry Parameter', OutputparamVARCHAR( -) COMMENT'interface out parameter', AppIdVARCHAR( -) COMMENT'App ID', BrowerversionVARCHAR( -) COMMENT'browerversion', LogTimeDATETIMECOMMENT'Log Time', CreatetimeDATETIME) ENGINE=INNODBDEFAULTCHARSET=UTF8; #指定引擎和存储字符类型ALTER TABLEApilog COMMENT'Interface Log';

Excerpt https://www.cnblogs.com/zery/p/6971902.html

MySQL CREATE table specifies the character type associated with the storage engine