07 2011 档案

• 【转】给 MySQL 增加 Sequence 管理功能
  摘要：-- Sequence 管理表DROP TABLE IF EXISTS sequence;CREATE TABLE sequence ( name VARCHAR(50) NOT NULL, current_value INT NOT NULL, increment INT NOT NULL DEFAULT 1, PRIMARY KEY (name)) ENGINE=InnoDB;-- 取当前值的函数DROP FUNCTION IF EXISTS currval;DELIMITER $CREATE FUNCTION currval (seq_name VARCHAR(50)) RETURNS 阅读全文
  posted @ 2011-07-11 16:58 attar 阅读(1790) 评论(0) 推荐(0)