VbzCart/procs/Upd CatPages: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
New page: ==About== '''Updates''': _cat_pages -> {{vbzcart|table|cat_pages}} ==SQL== <section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages() REPLACE INTO cat_pages SELECT * FROM _cat_pages ... |
m link to _cat_pages at its new address |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
'''Updates''': _cat_pages -> {{vbzcart|table|cat_pages}} | '''Updates''': {{vbzcart/query|_cat_pages}} -> {{vbzcart|table|cat_pages}} | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages() | <section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages() | ||
Revision as of 18:33, 8 March 2009
About
Updates: _cat_pages -> cat_pages
SQL
<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages()
REPLACE INTO cat_pages SELECT * FROM _cat_pages ORDER BY Path;</mysql>
<section end=sql />
