VbzCart/docs/queries/qrySub Carts info items: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(Created page with '==Details== * '''Requires''': {{vbzcart/table|shop_cart_line}} * '''History''': ** '''2009-09-08''' Created for Special:VbzAdmin ==SQL== <section begin=sql /><mysql>CREATE OR REP…')
 
m (Woozle moved page VbzCart/VbzCart/queries/qrySub Carts info items to VbzCart/docs/queries/qrySub Carts info items without leaving a redirect: part 3/5)
 
(One intermediate revision by one other user not shown)
Line 4: Line 4:
** '''2009-09-08''' Created for Special:VbzAdmin
** '''2009-09-08''' Created for Special:VbzAdmin
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qrySub_Carts_info_lines AS
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qrySub_Carts_info_items AS
SELECT
SELECT
   ID_Cart, COUNT(ID_Cart) AS DataCount
   ID_Cart, COUNT(ID_Cart) AS ItemCount
FROM shop_cart_line
FROM shop_cart_line
GROUP BY ID_Cart;</mysql>
GROUP BY ID_Cart;</mysql>
<section end=sql />
<section end=sql />

Latest revision as of 01:56, 25 February 2024

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 />