VbzCart/docs/queries/qrySub Carts info items

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search

Details

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qrySub_Carts_info_items AS SELECT

 ID_Cart, COUNT(ID_Cart) AS ItemCount

FROM shop_cart_line GROUP BY ID_Cart;</mysql> <section end=sql />