Robis Posted February 19, 2006 Report Share Posted February 19, 2006 Kā var updeitot mysql tabulu, kur vajag vienam ierakstam laukam, kura tips ir int(), palielināt vai samazanāt vērtību par 1, respektīvi - lai nav jāselekto un jāiegūst pašreizējā vērtība un pēc tam jāsūta vēl viens query, lai udpeitotu - kā to visu var izdarīt vienā querijā? Link to comment Share on other sites More sharing options...
v3rb0 Posted February 19, 2006 Report Share Posted February 19, 2006 update table set field=field+1 where id=123 Link to comment Share on other sites More sharing options...
bubu Posted February 19, 2006 Report Share Posted February 19, 2006 Kāpēc atkal neviens negrib dokumentāciju lasīt... Link to comment Share on other sites More sharing options...
Delfins Posted February 19, 2006 Report Share Posted February 19, 2006 Kurš nu ko, bet nebiju domājis ka pieredzējis Robis to nezinātu ;) Link to comment Share on other sites More sharing options...
Klez Posted February 19, 2006 Report Share Posted February 19, 2006 vinjam pieredze ir algas sanjemshanaa :DDD :) Link to comment Share on other sites More sharing options...
Kavacky Posted February 20, 2006 Report Share Posted February 20, 2006 Jau tā laba diena, bet nu vēl jautrāk palika. :D Link to comment Share on other sites More sharing options...
Recommended Posts