Results 1 to 8 of 8

Thread: SQLite

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered 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, ... .

  2. #2
    -==-
    Join Date: Sep:2003
    Location:
    Posts: 6,444
    SQL- ?
    Last edited by Yasen6275; 29th March 2017 at 21:46.
    He who asks is a fool for five minutes, but he who does not ask reamins a fool forever. Old Chinese saying
    Quote Originally Posted by worm4 View Post
    a .

  3. #3
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , sql . .
    sqlite , (INSERT) , ( ), , , ( ), - , .

  4. #4
    Banned
    Join Date: Feb:2006
    Location: ,
    Posts: 1,362
    update .
    update , , .
    Last edited by iliev72; 29th March 2017 at 22:29.

  5. #5
    Registered User
    Join Date: Jul:2009
    Location: Bulgaria
    Posts: 848
    Java SQL , . , SQL. 3 - , 4

    Code:
    SELECT *
    FROM highscores
    WHERE difficulty = ??
    ORDER BY score DESC
    LIMIT 3;
    sql .

    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, ... .

  6. #6
    Deleted User 4eRNoBiL's Avatar
    Join Date: Oct:2005
    Location:
    Posts: 739
    , . .
    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

  7. #7
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    Quote Originally Posted by 4eRNoBiL View Post
    , . .
    , , . , ..

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 |