Results 1 to 6 of 6
Thread: query MySQL
Hybrid View
-
18th February 2007 19:56 #1
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|
-
18th February 2007 20:12 #2
-
18th February 2007 21:39 #3
, 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|
-
19th February 2007 14:36 #4
. ""

: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()
-
19th February 2007 18:28 #5
.
:
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);
-
19th February 2007 19:24 #6
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|




Reply With Quote
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in