教你使用MySQL触发器自动更新Memcache[2]以下文字资料是由(历史新知网www.lishixinzhi.com)小编为大家搜集整理后发布的内容,让我们赶快一起来看一下吧!
以下测试脚本摘自memcached_functions_mysql的源码目录 有兴趣可以试试
PLAIN TEXTCODE: drop table if exists urls; create table urls ( id int( ) not null url varchar( ) not null default primary key (id) ); select memc_servers_set( localhost: ); select memc_set( urls:sequence ); DELIMITER | DROP TRIGGER IF EXISTS url_mem_insert; CREATE TRIGGER url_mem_insert BEFORE INSERT ON urls FOR EACH ROW BEGIN SET NEW id= memc_increment( urls:sequence ); SET @mm= memc_set(concat( urls: NEW id) NEW url); END | DELIMITER ; insert into urls (url) values ( //google ); insert into urls (url) values ( // ooso net/index php ); insert into urls (url) values ( // ooso net/ ); insert into urls (url) values ( //slashdot ); insert into urls (url) values ( //mysql ); select * from urls; select memc_get( urls: ); select memc_get( urls: ); select memc_get( urls: ); select memc_get( urls: ); select memc_get( urls: ); lishixinzhi/Article/program/MySQL/201311/29587
分页:123