VbzCart/coding/integrity checks

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | coding
Revision as of 23:53, 3 March 2016 by Woozle (talk | contribs) (Created page with "Table-specific checks: * {{l/vc/table|cat_items/integrity checks}} ==Cross-table checks== Package lines and order lines which don't agree about what ID_Item they're tracking:...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Table-specific checks:

Cross-table checks

Package lines and order lines which don't agree about what ID_Item they're tracking: <mysql>SELECT 

   *

FROM 

   ord_pkg_lines AS pl
       JOIN
   ord_lines AS ol ON pl.ID_OrdLine = ol.ID

WHERE 

   ol.ID_Item != pl.ID_Item</mysql>
Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/coding/integrity_checks&oldid=21776"