hoho Posted April 7, 2007 Report Posted April 7, 2007 cau! kaa var uztaisiit update uzreiz vairaakam tabulam, laukam ID, ja visas triis tabulas ir saistiitas peec si lauka?
andrisp Posted April 7, 2007 Report Posted April 7, 2007 Hmm.. man šķiet, ka reizē gan nevarēs. Jātaisa atsevišķi kveriji.
hoho Posted April 7, 2007 Author Report Posted April 7, 2007 bet kaa var atseviski, ja tas lauks, kuru vajag updatot, ir Foreign key un tad mysql kliedz, ka ir kljuda!!! :S
v3rb0 Posted April 7, 2007 Report Posted April 7, 2007 foreign keyam pieliec ON UPDATE CASCADE , padomā vai pareizā secībā updeito un vispār palasi http://dev.mysql.com/doc/refman/5.0/en/inn...onstraints.html
Recommended Posts