VbzCart/docs/procs/Upd CatPages: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (link to _cat_pages at its new address) |
imported>Woozle (_cat_pages -> qryCat_pages) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
'''Updates''': {{vbzcart/query| | * '''Updates''': {{vbzcart/query|qryCat_pages}} -> {{vbzcart|table|cat_pages}} | ||
* '''History''': | |||
** '''2009-12-11''' Revised to use qryCat_pages instead of _cat_pages, which had not been documented | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages() | <section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages() | ||
REPLACE INTO cat_pages | REPLACE INTO cat_pages | ||
SELECT * FROM | SELECT * FROM qryCat_pages | ||
ORDER BY Path;</mysql> | ORDER BY Path;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 12:14, 11 December 2009
About
- Updates: Template:Vbzcart/query -> Template:Vbzcart
- History:
- 2009-12-11 Revised to use qryCat_pages instead of _cat_pages, which had not been documented
SQL
<section begin=sql /><mysql>CREATE PROCEDURE Upd_CatPages()
REPLACE INTO cat_pages SELECT * FROM qryCat_pages ORDER BY Path;</mysql>
<section end=sql />