慢慢需找

摘要： Mysql5.1支持分区；创建表时创建分区（分区有rang分区、list分区、hash分区、key分区和子分区，具体详见：http://blog.51yip.com/mysql/1013.htmlcreate table testA (id int not null)engine=innodb partition by range(id)(partition p0 values less than (10),partition p1 values less than (MAXVALUE));查询某张表的分区信息（mysql必须支持分区，否则information库里不存在partition表） 阅读全文

摘要： 基本语法：CREATE [DEFINER = { user | CURRENT_USER }] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'comment'] DO event_body;schedule: AT timestamp [+ INTERVAL interval] ... | EVERY interva... 阅读全文

摘要： 基本语法：CREATE PROCEDURE sp_name ([proc_parameter[,...]]) [characteristic ...] routine_body CREATE FUNCTION sp_name ([func_parameter[,...]]) RETURNS type [characteristic ...] routine_body proc_parameter: [ IN | OUT | INOUT ] param_name type func_parameter: param_name type t... 阅读全文