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) |
m (Woozle moved page VbzCart/VbzCart/procs/Upd CatPages to VbzCart/docs/procs/Upd CatPages without leaving a redirect: part 2) |
||
| (One intermediate revision by one other user not shown) | |||
| 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 01:55, 25 February 2024
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 />