<code><span>drop table </span><span>
if
</span><span> exists urls</span><span>;</span><span>
create table urls </span><span>(</span><span>
id </span><span>int</span><span>(</span><span>3</span><span>)</span><span>not</span><span>null</span><span>,</span><span>
url varchar</span><span>(</span><span>64</span><span>)</span><span>not</span><span>null</span><span>
default
</span><span>
''
</span><span>,</span><span>
primary key </span><span>(</span><span>id</span><span>)</span><span>);</span><span>select</span><span> memc_servers_set</span><span>(</span><span>
'localhost:11211'
</span><span>);</span><span>select</span><span> memc_set</span><span>(</span><span>
'urls:sequence'
</span><span>,</span><span>0</span><span>);</span><span>
DELIMITER </span><span>|</span><span>
DROP TRIGGER IF EXISTS url_mem_insert</span><span>;</span><span>
CREATE TRIGGER url_mem_insert
BEFORE INSERT ON urls
FOR EACH ROW </span><span>BEGIN</span><span>
SET NEW</span><span>.</span><span>id</span><span>=</span><span> memc_increment</span><span>(</span><span>
'urls:sequence'
</span><span>);</span><span>
SET </span><span>@mm</span><span>=</span><span> memc_set</span><span>(</span><span>concat</span><span>(</span><span>
'urls:'
</span><span>,</span><span>NEW</span><span>.</span><span>id</span><span>),</span><span> NEW</span><span>.</span><span>url</span><span>);</span><span>
END
</span><span>|</span><span>
DELIMITER </span><span>;</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>
'http://google.com'
</span><span>);</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>
'http://www.ooso.net/index.php'
</span><span>);</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>
'http://www.ooso.net/'
</span><span>);</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>
'http://slashdot.org'
</span><span>);</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>
'http://mysql.com'
</span><span>);</span><span>select</span><span>*</span><span>from</span><span> urls</span><span>;</span><span>select</span><span> memc_get</span><span>(</span><span>
'urls:1'
</span><span>);</span><span>select</span><span> memc_get</span><span>(</span><span>
'urls:2'
</span><span>);</span><span>select</span><span> memc_get</span><span>(</span><span>
'urls:3'
</span><span>);</span><span>select</span><span> memc_get</span><span>(</span><span>
'urls:4'
</span><span>);</span><span>select</span><span> memc_get</span><span>(</span><span>
'urls:5'
</span><span>);</span></code>