1. 建立 内存数据库 create table test_memory( id int unsigned not null auto_increment,
url varchar(255) not null,
url_crc int unsigned not null default 0,
primary key(id));
create table test_memoryIndex( fname varchar(25) not null,
lname varchar(25) not null,
key using hash(fname) ) engine = memory;
sql 语句: select * from test_memory where url="http://mysql.com" and url_crc = crc32("http://mysql.com");
建立触发器:
delimiter//
create trigger test_memory_trigger_crc_ins before insert no test_memory for each row begin set New.url_crc= CRC32(NEW.url);
end;
create tigger test_memory_trigger_crc_update before update no test_memory for each row begin set New.url_crc = CRC32(NEW.url);
end;
delimiter ;//