VbzCart/procs/Upd TitleIttyps fr CatIttyps

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | procs
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • Input: cat_ittyps
  • Output: _title_ittyps (update)
  • History:
    • 2010-11-10
      • Added DROP PROCEDURE for easier maintenance.
      • Created in database (procs were not ported from L48 to Rizzo).

SQL

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

 UPDATE _title_ittyps AS ti LEFT JOIN cat_ittyps AS it ON ti.ID_ItTyp=it.ID
   SET
     ti.ItTypNameSng = it.NameSng,
     ti.ItTypNamePlr = it.NamePlr,
     ti.ItTypSort = it.Sort;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/procs/Upd_TitleIttyps_fr_CatIttyps&oldid=14429"