📄 mysql.cfg
字号:
func_odbc_user()=yes # Function USER()func_odbc_week=USA # WEEKfunc_odbc_year=yes # Function YEARfunc_sql_+=yes # Function +, -, * and /func_sql_bit_length=yes # Function BIT_LENGTHfunc_sql_cast=yes # Function CASTfunc_sql_char_length=error # Function CHAR_LENGTHfunc_sql_char_length(constant)=yes # Function CHAR_LENGTH(constant)func_sql_character_length=yes # Function CHARACTER_LENGTHfunc_sql_coalesce=yes # Function COALESCEfunc_sql_concat_as_||=error # Function concatenation with ||func_sql_current_date=yes # Function CURRENT_DATEfunc_sql_current_time=yes # Function CURRENT_TIMEfunc_sql_current_timestamp=yes # Function CURRENT_TIMESTAMPfunc_sql_current_user=yes # CURRENT_USERfunc_sql_extract_sql=yes # Function EXTRACTfunc_sql_localtime=yes # Function LOCALTIMEfunc_sql_localtimestamp=yes # Function LOCALTIMESTAMPfunc_sql_lower=yes # Function LOWERfunc_sql_nullif_num=yes # Function NULLIF with numbersfunc_sql_nullif_string=yes # Function NULLIF with stringsfunc_sql_octet_length=yes # Function OCTET_LENGTHfunc_sql_position=yes # Function POSITIONfunc_sql_searched_case=yes # Function searched CASEfunc_sql_session_user=with_parenthesis # SESSION_USERfunc_sql_simple_case=yes # Function simple CASEfunc_sql_substring=yes # Function ANSI SQL SUBSTRINGfunc_sql_system_user=with_parenthesis # SYSTEM_USERfunc_sql_trim=yes # Function TRIMfunc_sql_upper=yes # Function UPPERfunc_sql_user=with_parenthesis # USERfunc_where_between=yes # Function BETWEENfunc_where_eq_all=yes # Function = ALLfunc_where_eq_any=yes # Function = ANYfunc_where_eq_some=yes # Function = SOMEfunc_where_exists=yes # Function EXISTSfunc_where_in_num=yes # Function IN on numbersfunc_where_like=yes # Function LIKEfunc_where_like_escape=yes # Function LIKE ESCAPEfunc_where_match=no # Function MATCHfunc_where_match_unique=no # Function MATCH UNIQUEfunc_where_matches=no # Function MATCHESfunc_where_not_between=yes # Function NOT BETWEENfunc_where_not_exists=yes # Function NOT EXISTSfunc_where_not_like=yes # Function NOT LIKEfunc_where_not_unique=no # Function NOT UNIQUEfunc_where_unique=no # Function UNIQUEfunctions=yes # Functionsgroup_by=yes # Group bygroup_by_alias=yes # Group by aliasgroup_by_null=yes # Group on column with null valuesgroup_by_position=yes # Group by positiongroup_distinct_functions=yes # Group functions with distinctgroup_func_extra_bit_and=yes # Group function BIT_ANDgroup_func_extra_bit_or=yes # Group function BIT_ORgroup_func_extra_count_distinct_list=yes # Group function COUNT(DISTINCT expr,expr,...)group_func_extra_std=yes # Group function STDgroup_func_extra_stddev=yes # Group function STDDEVgroup_func_extra_variance=yes # Group function VARIANCEgroup_func_sql_any=no # Group function ANYgroup_func_sql_avg=yes # Group function AVGgroup_func_sql_count_*=yes # Group function COUNT (*)group_func_sql_count_column=yes # Group function COUNT column namegroup_func_sql_count_distinct=yes # Group function COUNT(DISTINCT expr)group_func_sql_every=no # Group function EVERYgroup_func_sql_max=yes # Group function MAX on numbersgroup_func_sql_max_str=yes # Group function MAX on stringsgroup_func_sql_min=yes # Group function MIN on numbersgroup_func_sql_min_str=yes # Group function MIN on stringsgroup_func_sql_some=no # Group function SOMEgroup_func_sql_sum=yes # Group function SUMgroup_functions=yes # Group functionsgroup_many_distinct_functions=yes # Group functions with several distinctgroup_on_unused=yes # Group on unused columnhas_true_false=yes # TRUE and FALSEhaving=yes # Havinghaving_with_alias=yes # Having on aliashaving_with_group=yes # Having with group functionhex_numbers=yes # hex numbers (0x41)hex_strings=yes # hex strings (x'1ace')ignore_end_space=yes # Ignore end space in compareindex_in_create=yes # index in create tableindex_namespace=yes # different namespace for indexindex_parts=yes # index on column part (extension)inner_join=yes # inner joininsert_default_values=no # INSERT DEFAULT VALUESinsert_empty_string=yes # insert empty stringinsert_multi_value=yes # INSERT with Value listsinsert_select=yes # insert INTO ... SELECT ...insert_with_default=yes # INSERT with DEFAULTinsert_with_empty_value_list=no # INSERT with empty value listinsert_with_set=yes # INSERT with set syntaxintersect=no # intersectintersect_all=no # intersect allintersect_all_incompat=no # intersect all (incompatible lists)intersect_incompat=no # intersect (incompatible lists)join_tables=61 # tables in joinleft_outer_join=yes # left outer joinleft_outer_join_using=yes # left outer join usinglength_of_varchar_field=actual length # CHARACTER_LENGTH(varchar_field)like_with_column=yes # column LIKE columnlike_with_number=yes # LIKE on numberslock_tables=yes # lock tablelogical_value=1 # Value of logical operation (1=1)max_big_expressions=10 # big expressionsmax_char_size=255 # max char() sizemax_column_name=64 # column name lengthmax_columns=2599 # Columns in tablemax_conditions=85660 # OR and AND in WHEREmax_expressions=580 # simple expressionsmax_index=+64 # max indexmax_index_length=1000 # index lengthmax_index_name=64 # index name lengthmax_index_part_length=255 # max index part lengthmax_index_parts=16 # index partsmax_index_varchar_part_length=1000 # index varchar part lengthmax_row_length=65534 # max table row length (without blobs)max_row_length_with_null=65502 # table row length with nulls (without blobs)max_select_alias_name=+512 # select alias name lengthmax_stack_expression=580 # stacked expressionsmax_table_alias_name=+512 # table alias name lengthmax_table_name=64 # table name lengthmax_text_size=1048543 # max text or blob sizemax_unique_index=+64 # unique indexesmax_varchar_size=1048543 # max varchar() sizeminus=no # minusminus_incompat=no # minus (incompatible lists)minus_neg=yes # Calculate 1--1multi_drop=yes # many tables to drop tablemulti_null_in_unique=yes # null in unique indexmulti_strings=yes # Multiple line stringsmulti_table_delete=yes # DELETE FROM table1,table2...multi_table_update=yes # Update with many tablesnatural_join=yes # natural joinnatural_join_incompat=yes # natural join (incompatible lists)natural_left_outer_join=yes # natural left outer joinno_primary_key=yes # Tables without primary keynot_id_between=yes # NOT ID BETWEEN interprets as ID NOT BETWEENnull_concat_expr=yes # Is concat('a',NULL) = NULLnull_in_index=yes # null in indexnull_in_unique=yes # null in unique indexnull_num_expr=yes # Is 1+NULL = NULLnulls_in_unique=yes # null combination in unique indexodbc_left_outer_join=yes # left outer join odbc styleoperating_system=Linux 2.6.8-my i686 # crash-me tested onorder_by=yes # Order byorder_by_alias=yes # Order by aliasorder_by_function=yes # Order by functionorder_by_position=yes # Order by positionorder_on_unused=yes # Order by on unused columnposition_of_null=first # Where is null values in sorted recordsetposition_of_null_desc=last # Where is null values in sorted recordset (DESC)primary_key_in_create=yes # primary key in create tablepsm_functions=no # PSM functions (ANSI SQL)psm_modules=no # PSM modules (ANSI SQL)psm_procedures=no # PSM procedures (ANSI SQL)psm_trigger=no # Triggers (ANSI SQL)query_size=1048574 # query sizequote_ident_with_"=error # " as identifier quote (ANSI SQL)quote_ident_with_[=no # [] as identifier quotequote_ident_with_`=yes # ` as identifier quotequote_ident_with_dbl_"=no # Double "" in identifiers as "quote_with_"=yes # Allows ' and " as string markersrecursive_subqueries=+64 # recursive subqueriesremember_end_space=no # Remembers end space in char()remember_end_space_varchar=yes # Remembers end space in varchar()rename_table=yes # rename tablerepeat_string_size=1048576 # return string size from functionreserved_word_ansi-92/99_absolute=no # Keyword ABSOLUTEreserved_word_ansi-92/99_action=no # Keyword ACTIONreserved_word_ansi-92/99_add=yes # Keyword ADDreserved_word_ansi-92/99_after=no # Keyword AFTERreserved_word_ansi-92/99_alias=no # Keyword ALIASreserved_word_ansi-92/99_all=yes # Keyword ALLreserved_word_ansi-92/99_allocate=no # Keyword ALLOCATEreserved_word_ansi-92/99_alter=yes # Keyword ALTERreserved_word_ansi-92/99_and=yes # Keyword ANDreserved_word_ansi-92/99_any=no # Keyword ANYreserved_word_ansi-92/99_are=no # Keyword AREreserved_word_ansi-92/99_as=yes # Keyword ASreserved_word_ansi-92/99_asc=yes # Keyword ASCreserved_word_ansi-92/99_assertion=no # Keyword ASSERTIONreserved_word_ansi-92/99_at=no # Keyword ATreserved_word_ansi-92/99_authorization=no # Keyword AUTHORIZATIONreserved_word_ansi-92/99_before=yes # Keyword BEFOREreserved_word_ansi-92/99_begin=no # Keyword BEGINreserved_word_ansi-92/99_bit=no # Keyword BITreserved_word_ansi-92/99_boolean=no # Keyword BOOLEANreserved_word_ansi-92/99_both=yes # Keyword BOTHreserved_word_ansi-92/99_breadth=no # Keyword BREADTHreserved_word_ansi-92/99_by=yes # Keyword BYreserved_word_ansi-92/99_call=yes # Keyword CALLreserved_word_ansi-92/99_cascade=yes # Keyword CASCADEreserved_word_ansi-92/99_cascaded=no # Keyword CASCADEDreserved_word_ansi-92/99_case=yes # Keyword CASEreserved_word_ansi-92/99_cast=no # Keyword CASTreserved_word_ansi-92/99_catalog=no # Keyword CATALOGreserved_word_ansi-92/99_char=yes # Keyword CHARreserved_word_ansi-92/99_character=yes # Keyword CHARACTERreserved_word_ansi-92/99_check=yes # Keyword CHECKreserved_word_ansi-92/99_close=no # Keyword CLOSEreserved_word_ansi-92/99_collate=yes # Keyword COLLATEreserved_word_ansi-92/99_collation=no # Keyword COLLATIONreserved_word_ansi-92/99_column=yes # Keyword COLUMNreserved_word_ansi-92/99_commit=no # Keyword COMMITreserved_word_ansi-92/99_completion=no # Keyword COMPLETIONreserved_word_ansi-92/99_connect=no # Keyword CONNECTreserved_word_ansi-92/99_connection=yes # Keyword CONNECTIONreserved_word_ansi-92/99_constraint=yes # Keyword CONSTRAINTreserved_word_ansi-92/99_constraints=no # Keyword CONSTRAINTSreserved_word_ansi-92/99_continue=yes # Keyword CONTINUEreserved_word_ansi-92/99_corresponding=no # Keyword CORRESPONDINGreserved_word_ansi-92/99_create=yes # Keyword CREATEreserved_word_ansi-92/99_cross=yes # Keyword CROSSreserved_word_ansi-92/99_current=no # Keyword CURRENTreserved_word_ansi-92/99_current_date=yes # Keyword CURRENT_DATEreserved_word_ansi-92/99_current_time=yes # Keyword CURRENT_TIMEreserved_word_ansi-92/99_current_timestamp=yes # Keyword CURRENT_TIMESTAMPreserved_word_ansi-92/99_current_user=yes # Keyword CURRENT_USERreserved_word_ansi-92/99_cursor=yes # Keyword CURSORreserved_word_ansi-92/99_cycle=no # Keyword CYCLEreserved_word_ansi-92/99_data=no # Keyword DATAreserved_word_ansi-92/99_date=no # Keyword DATEreserved_word_ansi-92/99_day=no # Keyword DAYreserved_word_ansi-92/99_deallocate=no # Keyword DEALLOCATEreserved_word_ansi-92/99_dec=yes # Keyword DECreserved_word_ansi-92/99_decimal=yes # Keyword DECIMALreserved_word_ansi-92/99_declare=yes # Keyword DECLAREreserved_word_ansi-92/99_default=yes # Keyword DEFAULTreserved_word_ansi-92/99_deferrable=no # Keyword DEFERRABLEreserved_word_ansi-92/99_deferred=no # Keyword DEFERREDreserved_word_ansi-92/99_delete=yes # Keyword DELETEreserved_word_ansi-92/99_depth=no # Keyword DEPTHreserved_word_ansi-92/99_desc=yes # Keyword DESCreserved_word_ansi-92/99_describe=yes # Keyword DESCRIBEreserved_word_ansi-92/99_descriptor=no # Keyword DESCRIPTORreserved_word_ansi-92/99_diagnostics=no # Keyword DIAGNOSTICSreserved_word_ansi-92/99_dictionary=no # Keyword DICTIONARYreserved_word_ansi-92/99_disconnect=no # Keyword DISCONNECTreserved_word_ansi-92/99_distinct=yes # Keyword DISTINCTreserved_word_ansi-92/99_domain=no # Keyword DOMAINreserved_word_ansi-92/99_double=yes # Keyword DOUBLEreserved_word_ansi-92/99_drop=yes # Keyword DROPreserved_word_ansi-92/99_each=yes # Keyword EACHreserved_word_ansi-92/99_else=yes # Keyword ELSEreserved_word_ansi-92/99_elseif=yes # Keyword ELSEIFreserved_word_ansi-92/99_end=no # Keyword ENDreserved_word_ansi-92/99_end-exec=yes # Keyword END-EXECreserved_word_ansi-92/99_equals=no # Keyword EQUALSreserved_word_ansi-92/99_escape=no # Keyword ESCAPEreserved_word_ansi-92/99_except=no # Keyword EXCEPTreserved_word_ansi-92/99_exception=no # Keyword EXCEPTIONreserved_word_ansi-92/99_exec=no # Keyword EXECreserved_word_ansi-92/99_execute=no # Keyword EXECUTEreserved_word_ansi-92/99_external=no # Keyword EXTERNALreserved_word_ansi-92/99_false=yes # Keyword FALSEreserved_word_ansi-92/99_fetch=yes # Keyword FETCHreserved_word_ansi-92/99_first=no # Keyword FIRSTreserved_word_ansi-92/99_float=yes # Keyword FLOATreserved_word_ansi-92/99_for=yes # Keyword FORreserved_word_ansi-92/99_foreign=yes # Keyword FOREIGNreserved_word_ansi-92/99_found=no # Keyword FOUNDreserved_word_ansi-92/99_from=yes # Keyword FROMreserved_word_ansi-92/99_full=no # Keyword FULLreserved_word_ansi-92/99_general=no # Keyword GENERALreserved_word_ansi-92/99_get=no # Keyword GETreserved_word_ansi-92/99_global=no # Keyword GLOBALreserved_word_ansi-92/99_go=no # Keyword GOreserved_word_ansi-92/99_goto=yes # Keyword GOTOreserved_word_ansi-92/99_grant=yes # Keyword GRANTreserved_word_ansi-92/99_group=yes # Keyword GROUPreserved_word_ansi-92/99_having=yes # Keyword HAVINGreserved_word_ansi-92/99_hour=no # Keyword HOURreserved_word_ansi-92/99_identity=no # Keyword IDENTITYreserved_word_ansi-92/99_if=yes # Keyword IFreserved_word_ansi-92/99_ignore=yes # Keyword IGNOREreserved_word_ansi-92/99_immediate=no # Keyword IMMEDIATEreserved_word_ansi-92/99_in=yes # Keyword INreserved_word_ansi-92/99_indicator=no # Keyword INDICATORreserved_word_ansi-92/99_initially=no # Keyword INITIALLY
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -