Linčesters Posted December 26, 2010 Report Share Posted December 26, 2010 (edited) Kā īsti var dublēt datus tabulas laukos? Piemēram man ir tabulā tbl_tabula lauks insert_data. Respektīvi es pielieku klāt vēl vienu lauku position un vēlos pārkopēt no lauka insert_data visus tajā esošos ierakstus uz lauku position lai visi dati laukā position ir tādi paši kā laukā insert_data tiem pašiem ID. Kā to ātrāk panākt? Edited December 26, 2010 by Linčesters Quote Link to comment Share on other sites More sharing options...
briedis Posted December 26, 2010 Report Share Posted December 26, 2010 Uzraksti trigeri: (ask google) mysql triggers Quote Link to comment Share on other sites More sharing options...
Rincewind Posted December 26, 2010 Report Share Posted December 26, 2010 Vienreizējs pasākums, pārkopēt datus no lauka insert_data uz lauku position? UPDATE tabula SET position=insert_data Quote Link to comment Share on other sites More sharing options...
Linčesters Posted December 26, 2010 Author Report Share Posted December 26, 2010 Vienreizējs pasākums, pārkopēt datus no lauka insert_data uz lauku position? UPDATE tabula SET position=insert_data Paldies cepums Tev, nezināju ka šādi var izdarīt :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.