[<<][sql][>>][..]
Sat Nov 12 10:28:35 EST 2011

Views

DROP VIEW v_entry;
CREATE VIEW v_entry AS select * from 
       entry NATURAL JOIN
       vhost NATURAL JOIN
       ip    NATURAL JOIN
       stat  NATURAL JOIN
       req   NATURAL JOIN
       ref   NATURAL JOIN
       agent;

DROP VIEW v_blog;       
CREATE VIEW v_blog AS
       select * from req where req regexp 'GET (.*)/blog/\\?p=';



[Reply][About]
[<<][sql][>>][..]