Results 1 to 6 of 6

Thread: query MySQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833

    query MySQL

    :

    SELECT rs.author, sum( rs.counter ) FROM
    (SELECT b.author1 AS author, count( 1 ) AS counter FROM books b GROUP BY author1
    UNION ALL
    SELECT b.author2 AS author, count( 1 ) AS counter FROM books b GROUP BY author2
    UNION ALL
    SELECT b.author3 AS author, count( 1 ) AS counter FROM books b GROUP BY author3 )rs
    WHERE rs.author IS NOT NULL GROUP BY rs.author

    ySQL 5, 4 - , , .

    , , .

    , MYSQL 4.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  2. #2
    Banned haste's Avatar
    Join Date: Mar:2006
    Location:
    Posts: 759
    ?

  3. #3
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    , FROM.
    .
    - . , -.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  4. #4
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,387
    . ""
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

  5. #5
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331
    .
    :

    Code:
    $unique_names = mysql_query("SELECT DISTINCT ,2,3 FROM  1,2,3..");
    Code:
    $times = mysql_result(mysql_query("SELECT COUNT(DISTINCT ,2,3) as Num FROM  1,2,3...."),0);

  6. #6
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    MySQL 4 , , @ , , . 4 , 3 ... .
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |