Klez Posted July 24, 2005 Report Share Posted July 24, 2005 mekleeju mysql manuaali bet neatradu, man intresee vai insert un update ir iespeejams palaist ar vienu query .. ? Link to comment Share on other sites More sharing options...
bubu Posted July 24, 2005 Report Share Posted July 24, 2005 Var. Skaties REPLACE. Link to comment Share on other sites More sharing options...
Klez Posted July 24, 2005 Author Report Share Posted July 24, 2005 nu man vaig tabulaa t1 ievietot un tabulaa t2 apdeitot.. Replace derees ? Link to comment Share on other sites More sharing options...
bubu Posted July 24, 2005 Report Share Posted July 24, 2005 Nē, relpace der ja vajag vienā tabulā. Tipa ja ieraksta nav tad inserto, ja ir (meklēšana pēc primārās atslēgas), tad updeito. Tev ar vienu kveriju neiztikt. Ja nu vienīgi lietot mysql5, kur var rakstīt storētās procedūras (vismaz man tā šķiet, ka var), tad var uz servera izveidot tādu, kur ieliek abus kverijus, un no php izsaukt tikai to procedūru. A kas vainas diviem kverijiem? Link to comment Share on other sites More sharing options...
Kavacky Posted July 24, 2005 Report Share Posted July 24, 2005 Varbūt jāraksta divreiz vairāk. :) Link to comment Share on other sites More sharing options...
Klez Posted July 24, 2005 Author Report Share Posted July 24, 2005 domaaju lai mazaak resursus eed... :) delete pa divaam tableem to4 var , man liekas ka delete var pa vairaak tabulaam. vienk kad pievieno zinjai komentaaru, tad zinju tabulaa komentaaram vaig apdeitot vienu field , taapeec domaaju ka var iztikt ar vienu query ... :) buus jaadzivo ar diviem Link to comment Share on other sites More sharing options...
Recommended Posts