Difference between revisions of "VbzCart/procs/Upd CatPages"
Jump to navigation
Jump to search
m (link to _cat_pages at its new address) |
(_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 /> |
Latest revision as of 12:14, 11 December 2009
About
- Updates:
- REDIRECT Template:l/vc/query -> cat_pages
- History:
- 2009-12-11 Revised to use qryCat_pages instead of _cat_pages, which had not been documented
SQL
<mysql>CREATE PROCEDURE Upd_CatPages()
REPLACE INTO cat_pages SELECT * FROM qryCat_pages ORDER BY Path;</mysql>