流 年

一、创建数据库

CREATE DATABASE `{$db_name}` CHARACTER SET utf8 COLLATE utf8_general_ci;

二、刷新MySQL缓存

FLUSH PRIVILEGES;

三、新建 MySQL账户和密码

INSERT INTO mysql.user(Host,User,Password) VALUES('%','{$db_user}',PASSWORD('{$db_password}')); 

四、将新“数据库”授权给新创键MySQL账户

GRANT ALL PRIVILEGES ON  `{$db_name}` . * TO  '{$db_user}'@'%' WITH GRANT OPTION ;

注意：Mysql5.6以后，第三、四（授权）步骤改为：

GRANT ALL PRIVILEGES ON  `{$db_name}` . * TO  '{$db_user}'@'%' IDENTIFIED BY '{$db_password}' WITH GRANT OPTION ;

存储函数

--
-- 创建ID表
--
CREATE TABLE IF NOT EXISTS `ppos_seq` (
  `seq_name` varchar(100) NOT NULL,
  `seq_val` int(10) unsigned NOT NULL,
  PRIMARY KEY (`seq_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- 创建存储函数：每次调用函数时，自增1
--

delimiter //
CREATE FUNCTION `seq`(`select_name` CHAR(100)) RETURNS int(11)
    DETERMINISTIC
BEGIN
    UPDATE ppos_seq SET seq_val=last_insert_id(seq_val+1) WHERE seq_name=select_name;
    RETURN last_insert_id();
END //
delimiter ;