2009 年 6月 18 日随笔档案 - jinzhenshui

2009年6月18日

Mysql：函数之三： date and time functions：重要的格式化函数

摘要： DATE_FORMAT(date,format_str) Formats the date value according to the format string. The following specifiers may be used in the format string. The “%” character is required before format s... 阅读全文

posted @ 2009-06-18 16:15 jinzhenshui 阅读(351) 评论(0) 推荐(0)

Mysql：函数之三： date and time functions

摘要： 11.6.Date and Time Functions11.6.Date and Time FunctionsThis section describes the functions that can be used to manipulate temporal values. See Section10.3, “Date and Time Types”, for a d... 阅读全文

posted @ 2009-06-18 15:35 jinzhenshui 阅读(709) 评论(0) 推荐(0)

Mysql：函数之二： miscellaneous functions

摘要： Miscellaneous FunctionsNameDescriptionDEFAULT()Return the default value for a table columnGET_LOCK()Get a named lockINET_ATON()Return the numeric value of an IP addressINET_NTOA()Return the IP address... 阅读全文

posted @ 2009-06-18 13:59 jinzhenshui 阅读(233) 评论(0) 推荐(0)

Mysql：命令选项、配置选项、（全局、会话）系统变量、状态变量：状态变量

摘要： Server Status VariablesThe server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | SESSION] STATUS statement (see Section12.5.5.37, “SHOW STATUS Syntax”). The optional GLOBAL keyword aggregates the 阅读全文

posted @ 2009-06-18 09:11 jinzhenshui 阅读(567) 评论(0) 推荐(0)

Mysql：命令选项、配置选项、（全局、会话）系统变量、状态变量：（动态）系统变量

摘要： Dynamic System VariablesMany server system variables are dynamic and can be set at runtime using SET GLOBAL or SET SESSION. You can also obtain their values using SELECT. See Section5.1.5, “Usin... 阅读全文

posted @ 2009-06-18 09:09 jinzhenshui 阅读(342) 评论(0) 推荐(0)

Mysql：命令选项、配置选项、（全局、会话）系统变量、状态变量：（仅会话）系统变量

摘要： Session System VariablesSeveral system variables exist only as session variables. These cannot be set at server startup but can be assigned values at runtime using the SET statement (except for those ... 阅读全文

posted @ 2009-06-18 09:01 jinzhenshui 阅读(420) 评论(0) 推荐(0)

Mysql：命令选项、配置选项、（全局、会话）系统变量、状态变量：系统变量

摘要： Server System VariablesThe MySQL server maintains many system variables that indicate how it is configured. Each system variable has a default value. System variables can be set at server startup usin... 阅读全文

posted @ 2009-06-18 09:00 jinzhenshui 阅读(794) 评论(0) 推荐(0)

Mysql：命令选项、配置选项、（全局、会话）系统变量、状态变量：命令选项

摘要： Server Command OptionsWhen you start the mysqld server, you can specify program options using any of the methods described in Section4.2.3, “Specifying Program Options”. The most common me... 阅读全文

posted @ 2009-06-18 08:58 jinzhenshui 阅读(551) 评论(0) 推荐(0)

Mysql：命令选项、配置选项、（全局、会话）系统变量、状态变量：总揽

摘要： Server Option and Variable ReferenceThe following table provides a list of all the command line options, server and status variables applicable within mysqld. The table lists command-line options (Cmd... 阅读全文

posted @ 2009-06-18 06:23 jinzhenshui 阅读(357) 评论(0) 推荐(0)