Results 1 to 8 of 8
Thread: SQLite
Hybrid View
-
29th March 2017 21:30 #1Registered User
Join Date: Jul:2009
Location: Bulgaria
Posts: 848
SQLite
SQLite ? 9 3 3 . 9 - . . .

, 2 scores , difficulty , 3 .Last edited by atom3; 29th March 2017 at 21:34.
Alienware 17 R4, i7-6700hq, gtx-1060 OC, 16gb ddr4 2667 ram 256gb NVMe SSD, LSP, MMS, GPRS, UPS, FedEx, ZDR, kopr?, asl, W2F, ... .
-
29th March 2017 21:46 #2-==-
Join Date: Sep:2003
Location:
Posts: 6,444
-
29th March 2017 21:57 #3
, sql . .
sqlite , (INSERT) , ( ), , , ( ), - , .
-
29th March 2017 21:58 #4Banned
Join Date: Feb:2006
Location: ,
Posts: 1,362
update .
update
, , .
Last edited by iliev72; 29th March 2017 at 22:29.
-
29th March 2017 23:14 #5Registered User
Join Date: Jul:2009
Location: Bulgaria
Posts: 848
Java SQL , . , SQL. 3 - , 4
sql .Code:SELECT * FROM highscores WHERE difficulty = ?? ORDER BY score DESC LIMIT 3;
DELETE FROM highscores
WHERE difficulty = ??
AND ID NOT IN (SELECT ID
FROM highscores
WHERE difficulty = ??
ORDER BY score DESC
LIMIT 3);Last edited by atom3; 29th March 2017 at 23:23.
Alienware 17 R4, i7-6700hq, gtx-1060 OC, 16gb ddr4 2667 ram 256gb NVMe SSD, LSP, MMS, GPRS, UPS, FedEx, ZDR, kopr?, asl, W2F, ... .
-
30th March 2017 11:52 #6
, . .
Fujistu Lifebook E756 | Core i7-6500U / 400MHz-3.1GHz | 8 GB DDR4-2133 | Samsung PM871 / 256 GB SSD | 15" 1920x1080 | Manjaro Linux + kernel 4.19
-
30th March 2017 12:08 #7




Reply With Quote

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