📄 mysql.cfg
字号:
reserved_word_extra_distributed=no # Keyword DISTRIBUTEDreserved_word_extra_dummy=no # Keyword DUMMYreserved_word_extra_dump=no # Keyword DUMPreserved_word_extra_enclosed=yes # Keyword ENCLOSEDreserved_word_extra_errlvl=no # Keyword ERRLVLreserved_word_extra_errors=no # Keyword ERRORSreserved_word_extra_escaped=yes # Keyword ESCAPEDreserved_word_extra_exclusive=no # Keyword EXCLUSIVEreserved_word_extra_explain=yes # Keyword EXPLAINreserved_word_extra_fields=no # Keyword FIELDSreserved_word_extra_file=no # Keyword FILEreserved_word_extra_fillfactor=no # Keyword FILLFACTORreserved_word_extra_freetext=no # Keyword FREETEXTreserved_word_extra_freetexttable=no # Keyword FREETEXTTABLEreserved_word_extra_fulltext=yes # Keyword FULLTEXTreserved_word_extra_geometry=no # Keyword GEOMETRYreserved_word_extra_hash=no # Keyword HASHreserved_word_extra_high_priority=yes # Keyword HIGH_PRIORITYreserved_word_extra_holdlock=no # Keyword HOLDLOCKreserved_word_extra_hour_minute=yes # Keyword HOUR_MINUTEreserved_word_extra_hour_second=yes # Keyword HOUR_SECONDreserved_word_extra_identified=no # Keyword IDENTIFIEDreserved_word_extra_identity_insert=no # Keyword IDENTITY_INSERTreserved_word_extra_identitycol=no # Keyword IDENTITYCOLreserved_word_extra_increment=no # Keyword INCREMENTreserved_word_extra_index=yes # Keyword INDEXreserved_word_extra_infile=yes # Keyword INFILEreserved_word_extra_initial=no # Keyword INITIALreserved_word_extra_innodb=no # Keyword INNODBreserved_word_extra_keys=yes # Keyword KEYSreserved_word_extra_kill=yes # Keyword KILLreserved_word_extra_lineno=no # Keyword LINENOreserved_word_extra_lines=yes # Keyword LINESreserved_word_extra_load=yes # Keyword LOADreserved_word_extra_lock=yes # Keyword LOCKreserved_word_extra_long=yes # Keyword LONGreserved_word_extra_longblob=yes # Keyword LONGBLOBreserved_word_extra_longtext=yes # Keyword LONGTEXTreserved_word_extra_low_priority=yes # Keyword LOW_PRIORITYreserved_word_extra_master_server_id=no # Keyword MASTER_SERVER_IDreserved_word_extra_maxextents=no # Keyword MAXEXTENTSreserved_word_extra_mediumblob=yes # Keyword MEDIUMBLOBreserved_word_extra_mediumint=yes # Keyword MEDIUMINTreserved_word_extra_mediumtext=yes # Keyword MEDIUMTEXTreserved_word_extra_middleint=yes # Keyword MIDDLEINTreserved_word_extra_minus=no # Keyword MINUSreserved_word_extra_minute_second=yes # Keyword MINUTE_SECONDreserved_word_extra_mlslabel=no # Keyword MLSLABELreserved_word_extra_mode=no # Keyword MODEreserved_word_extra_mrg_myisam=no # Keyword MRG_MYISAMreserved_word_extra_noaudit=no # Keyword NOAUDITreserved_word_extra_nocheck=no # Keyword NOCHECKreserved_word_extra_nocompress=no # Keyword NOCOMPRESSreserved_word_extra_nonclustered=no # Keyword NONCLUSTEREDreserved_word_extra_nowait=no # Keyword NOWAITreserved_word_extra_number=no # Keyword NUMBERreserved_word_extra_offline=no # Keyword OFFLINEreserved_word_extra_offsets=no # Keyword OFFSETSreserved_word_extra_online=no # Keyword ONLINEreserved_word_extra_opendatasource=no # Keyword OPENDATASOURCEreserved_word_extra_openquery=no # Keyword OPENQUERYreserved_word_extra_openrowset=no # Keyword OPENROWSETreserved_word_extra_openxml=no # Keyword OPENXMLreserved_word_extra_optimize=yes # Keyword OPTIMIZEreserved_word_extra_optionally=yes # Keyword OPTIONALLYreserved_word_extra_outfile=yes # Keyword OUTFILEreserved_word_extra_over=no # Keyword OVERreserved_word_extra_pctfree=no # Keyword PCTFREEreserved_word_extra_percent=no # Keyword PERCENTreserved_word_extra_plan=no # Keyword PLANreserved_word_extra_print=no # Keyword PRINTreserved_word_extra_proc=no # Keyword PROCreserved_word_extra_purge=yes # Keyword PURGEreserved_word_extra_raiserror=no # Keyword RAISERRORreserved_word_extra_raw=no # Keyword RAWreserved_word_extra_readtext=no # Keyword READTEXTreserved_word_extra_reconfigure=no # Keyword RECONFIGUREreserved_word_extra_regexp=yes # Keyword REGEXPreserved_word_extra_rename=yes # Keyword RENAMEreserved_word_extra_replication=no # Keyword REPLICATIONreserved_word_extra_require=yes # Keyword REQUIREreserved_word_extra_resource=no # Keyword RESOURCEreserved_word_extra_restore=no # Keyword RESTOREreserved_word_extra_rlike=yes # Keyword RLIKEreserved_word_extra_rowcount=no # Keyword ROWCOUNTreserved_word_extra_rowguidcol=no # Keyword ROWGUIDCOLreserved_word_extra_rowid=no # Keyword ROWIDreserved_word_extra_rownum=no # Keyword ROWNUMreserved_word_extra_rtree=no # Keyword RTREEreserved_word_extra_rule=no # Keyword RULEreserved_word_extra_save=no # Keyword SAVEreserved_word_extra_setuser=no # Keyword SETUSERreserved_word_extra_share=no # Keyword SHAREreserved_word_extra_show=yes # Keyword SHOWreserved_word_extra_shutdown=no # Keyword SHUTDOWNreserved_word_extra_soname=yes # Keyword SONAMEreserved_word_extra_spatial=yes # Keyword SPATIALreserved_word_extra_sql_big_result=yes # Keyword SQL_BIG_RESULTreserved_word_extra_sql_calc_found_rows=yes # Keyword SQL_CALC_FOUND_ROWSreserved_word_extra_sql_small_result=yes # Keyword SQL_SMALL_RESULTreserved_word_extra_ssl=yes # Keyword SSLreserved_word_extra_starting=yes # Keyword STARTINGreserved_word_extra_statistics=no # Keyword STATISTICSreserved_word_extra_straight_join=yes # Keyword STRAIGHT_JOINreserved_word_extra_striped=no # Keyword STRIPEDreserved_word_extra_successful=no # Keyword SUCCESSFULreserved_word_extra_synonym=no # Keyword SYNONYMreserved_word_extra_sysdate=no # Keyword SYSDATEreserved_word_extra_tables=no # Keyword TABLESreserved_word_extra_terminated=yes # Keyword TERMINATEDreserved_word_extra_textsize=no # Keyword TEXTSIZEreserved_word_extra_tinyblob=yes # Keyword TINYBLOBreserved_word_extra_tinyint=yes # Keyword TINYINTreserved_word_extra_tinytext=yes # Keyword TINYTEXTreserved_word_extra_top=no # Keyword TOPreserved_word_extra_tran=no # Keyword TRANreserved_word_extra_truncate=no # Keyword TRUNCATEreserved_word_extra_tsequal=no # Keyword TSEQUALreserved_word_extra_types=no # Keyword TYPESreserved_word_extra_uid=no # Keyword UIDreserved_word_extra_unlock=yes # Keyword UNLOCKreserved_word_extra_unsigned=yes # Keyword UNSIGNEDreserved_word_extra_updatetext=no # Keyword UPDATETEXTreserved_word_extra_use=yes # Keyword USEreserved_word_extra_user_resources=no # Keyword USER_RESOURCESreserved_word_extra_validate=no # Keyword VALIDATEreserved_word_extra_varbinary=yes # Keyword VARBINARYreserved_word_extra_varchar2=no # Keyword VARCHAR2reserved_word_extra_waitfor=no # Keyword WAITFORreserved_word_extra_warnings=no # Keyword WARNINGSreserved_word_extra_writetext=no # Keyword WRITETEXTreserved_word_extra_xor=yes # Keyword XORreserved_word_extra_year_month=yes # Keyword YEAR_MONTHreserved_word_extra_zerofill=yes # Keyword ZEROFILLright_outer_join=yes # right outer joinrollback_metadata=no # rollback_metadatarowid=auto_increment # Type for row idsafe_decimal_arithmetic=yes # safe decimal arithmeticselect_constants=yes # Select constantsselect_limit=with LIMIT # LIMIT number of rowsselect_limit2=yes # SELECT with LIMIT #,#select_limit3=yes # SELECT with LIMIT # OFFSET #select_string_size=1048565 # constant string size in SELECTselect_table_update=yes # Update with sub selectselect_without_from=yes # SELECT without FROMserver_version=MySQL 5.0.7 beta valgrind max debug/ # server versionsimple_joins=yes # ANSI SQL simple joinssorted_group_by=yes # Group by always sortedstorage_of_float=round # Storage of float valuessubqueries=yes # subqueriestable_alias=yes # Table aliastable_name_case=no # case independent table namestable_wildcard=yes # Select table_name.*temporary_table=yes # temporary tablestime_format_EUR=error # Supports HH.MM.SS (EUR) time formattime_format_HHHHMMSS=yes # Supports HHHHmmSS time formattime_format_ISO=yes # Supports HH:MM:SS (ISO) time formattime_format_USA=error # Supports HH:MM:SS (AM|PM) time formattime_format_inresult=iso # Time format in resulttransactions=yes # transactionstruncate_table=yes # truncatetype_extra_abstime=no # Type abstimetype_extra_bfile=no # Type bfiletype_extra_blob=yes # Type blobtype_extra_bool=yes # Type booltype_extra_box=no # Type boxtype_extra_byte=no # Type bytetype_extra_char(1_arg)_binary=yes # Type char(1 arg) binarytype_extra_cidr=no # Type cidrtype_extra_circle=no # Type circletype_extra_clob=no # Type clobtype_extra_datetime=yes # Type datetimetype_extra_double=yes # Type doubletype_extra_enum(1_arg)=yes # Type enum(1 arg)type_extra_float(2_arg)=yes # Type float(2 arg)type_extra_float4=yes # Type float4type_extra_float8=yes # Type float8type_extra_image=no # Type imagetype_extra_inet=no # Type inettype_extra_int(1_arg)_zerofill=yes # Type int(1 arg) zerofilltype_extra_int1=yes # Type int1type_extra_int2=yes # Type int2type_extra_int3=yes # Type int3type_extra_int4=yes # Type int4type_extra_int8=yes # Type int8type_extra_int_auto_increment=yes # Type int not null auto_incrementtype_extra_int_identity=no # Type int not null identitytype_extra_int_unsigned=yes # Type int unsignedtype_extra_interval=no # Type intervaltype_extra_line=no # Type linetype_extra_long=yes # Type longtype_extra_long_raw=no # Type long rawtype_extra_long_varbinary=yes # Type long varbinarytype_extra_long_varchar(1_arg)=no # Type long varchar(1 arg)type_extra_lseg=no # Type lsegtype_extra_macaddr=no # Type macaddrtype_extra_mediumint=yes # Type mediuminttype_extra_mediumtext=yes # Type mediumtexttype_extra_middleint=yes # Type middleinttype_extra_mlslabel=no # Type mlslabeltype_extra_money=no # Type moneytype_extra_nclob=no # Type nclobtype_extra_number=no # Type numbertype_extra_number(1_arg)=no # Type number(1 arg)type_extra_number(2_arg)=no # Type number(2 arg)type_extra_nvarchar2(1_arg)=no # Type nvarchar2(1 arg)type_extra_path=no # Type pathtype_extra_point=yes # Type pointtype_extra_polygon=yes # Type polygontype_extra_raw(1_arg)=no # Type raw(1 arg)type_extra_reltime=no # Type reltimetype_extra_rowid=no # Type rowidtype_extra_serial=yes # Type serialtype_extra_set(1_arg)=yes # Type set(1 arg)type_extra_smalldatetime=no # Type smalldatetimetype_extra_smallfloat=no # Type smallfloattype_extra_smallmoney=no # Type smallmoneytype_extra_text=yes # Type texttype_extra_text(1_arg)=yes # Type text(1 arg)type_extra_timespan=no # Type timespantype_extra_uint=no # Type uinttype_extra_varchar2(1_arg)=no # Type varchar2(1 arg)type_extra_year=yes # Type yeartype_odbc_bigint=yes # Type biginttype_odbc_binary(1_arg)=yes # Type binary(1 arg)type_odbc_datetime=yes # Type datetimetype_odbc_tinyint=yes # Type tinyinttype_odbc_varbinary(1_arg)=yes # Type varbinary(1 arg)type_sql_bit=yes # Type bittype_sql_bit(1_arg)=yes # Type bit(1 arg)type_sql_bit_varying(1_arg)=no # Type bit varying(1 arg)type_sql_boolean=yes # Type booleantype_sql_char(1_arg)=yes # Type char(1 arg)type_sql_char_varying(1_arg)=yes # Type char varying(1 arg)type_sql_character(1_arg)=yes # Type character(1 arg)type_sql_character_varying(1_arg)=yes # Type character varying(1 arg)type_sql_date=yes # Type datetype_sql_dec(2_arg)=yes # Type dec(2 arg)type_sql_decimal(2_arg)=yes # Type decimal(2 arg)type_sql_double_precision=yes # Type double precisiontype_sql_float=yes # Type floattype_sql_float(1_arg)=yes # Type float(1 arg)type_sql_int=yes # Type inttype_sql_integer=yes # Type integertype_sql_interval_day=no # Type interval daytype_sql_interval_day_to_hour=no # Type interval day to hourtype_sql_interval_day_to_minute=no # Type interval day to minutetype_sql_interval_day_to_second=no # Type interval day to secondtype_sql_interval_hour=no # Type interval hourtype_sql_interval_hour_to_minute=no # Type interval hour to minutetype_sql_interval_hour_to_second=no # Type interval hour to secondtype_sql_interval_minute=no # Type interval minutetype_sql_interval_minute_to_second=no # Type interval minute to secondtype_sql_interval_month=no # Type interval monthtype_sql_interval_second=no # Type interval secondtype_sql_interval_year=no # Type interval yeartype_sql_interval_year_to_month=no # Type interval year to monthtype_sql_national_char_varying(1_arg)=yes # Type national char varying(1 arg)type_sql_national_character(1_arg)=yes # Type national character(1 arg)type_sql_national_character_varying(1_arg)=yes # Type national character varying(1 arg)type_sql_nchar(1_arg)=yes # Type nchar(1 arg)type_sql_nchar_varying(1_arg)=yes # Type nchar varying(1 arg)type_sql_numeric(2_arg)=yes # Type numeric(2 arg)type_sql_real=yes # Type realtype_sql_smallint=yes # Type smallinttype_sql_time=yes # Type timetype_sql_timestamp=yes # Type timestamptype_sql_timestamp_with_time_zone=no # Type timestamp with time zonetype_sql_varchar(1_arg)=yes # Type varchar(1 arg)union=yes # unionunion_all=yes # union allunion_all_incompat=yes # union all (incompatible lists)union_incompat=yes # union (incompatible lists)unique_in_create=yes # unique in create tableunique_null_in_create=yes # unique null in createvalue_of_false=0 # Value of FALSEvalue_of_true=1 # Value of TRUEviews=yes # viewswhere_string_size=1048539 # constant string size in where
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -