VbzCart/docs/procs/Upd Titles fr Depts

From Woozle Writes Code

< VbzCart‎ | docs‎ | procs

Jump to navigation Jump to search

About

Input: Template:Vbzcart, Template:Vbzcart
Output: Template:Vbzcart
History:
- 2010-11-10
  - Revised SQL to use "cat_titles" instead of "titles" (obsolete table which has been dropped).
  - Added "DROP PROCEDURE" line for easier maintenance.
  - Created in database (none of the procs had been ported from L48 to Rizzo).

SQL

<mysql>DROP PROCEDURE IF EXISTS Upd_Titles_fr_Depts; CREATE PROCEDURE Upd_Titles_fr_Depts()

 REPLACE INTO _titles(ID,ID_Supp,CatNum,CatWeb)
 SELECT
   t.ID,
   d.ID_Supp,
   UPPER(CONCAT_WS("-",d.CatNum,t.CatKey)) AS CatNum,
   LOWER(CONCAT_WS("/",d.CatWeb_Title,t.CatKey)) AS CatWeb
 FROM cat_titles AS t LEFT JOIN _depts AS d ON t.ID_dept=d.ID
 ORDER BY CatNum;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/procs/Upd_Titles_fr_Depts&oldid=6719"