sh4m_1 0 Report post Posted February 22, 2009 tiga2 table ni ade book_code and book_titletp aku nak update book_title = shamhensem tp book_code adalah 1001setiap table dalam book_code adalah unique (xde no sama)....camne nak wat..?? Quote Share this post Link to post Share on other sites
tengkubasri 0 Report post Posted February 22, 2009 asal cam pelik je table2 ko wat ni... da book code tu je yg unique, nape nak sumbat book title dkt table2 lain gak...satu table da cukup tuk store book_code + book_title + author + etc...table2 lain letak book_code as Foreign Key(FK) pon cukup ler... so ko update book_title dkt satu table tu je, takyah pening2 nak update dkt sume table, jenuh nak update... ::lol:: Quote Share this post Link to post Share on other sites
MatchMaker 0 Report post Posted February 23, 2009 macam kata tengkubasri, sepatutnya ada satu reference table.kalau dah berulang camni, mesti ko nyer ERD pun ada peoblem nih. Quote Share this post Link to post Share on other sites
titanbullet 0 Report post Posted February 27, 2009 tumpang lalu..tengkubasri,aku xtau soklan aku betul atau x. kalau pakai engine MyISAM x bole letak Fk kan? kalau InnoDB baru bole letak FK kan? aku pakai phpmyadmin, tp x pandai guna command..sham,kau pakai engine aper?er.. betul ke cara aku tanya nih? hehehe.. ::icon_bounce:: Quote Share this post Link to post Share on other sites
sh4m_1 0 Report post Posted February 28, 2009 memang lari skit la erd....nak wat camne.. tgh2 coding... skali org ni mintak macam tu....aku wat la sperate.. nak search 3 3 table ni, ok aku pakai UNION method...tp nak update je mengom skit...ade ke syntax lain utk update 3 3 table ni.... Quote Share this post Link to post Share on other sites
tengkubasri 0 Report post Posted March 7, 2009 titanbullet wrote:tumpang lalu..tengkubasri,aku xtau soklan aku betul atau x. kalau pakai engine MyISAM x bole letak Fk kan? kalau InnoDB baru bole letak FK kan? aku pakai phpmyadmin, tp x pandai guna command..sham,kau pakai engine aper?er.. betul ke cara aku tanya nih? hehehe.. ::icon_bounce::tuk FK mmg kene pakai innoDb. myIsam tak blh. kena pandai godek skit. rasanya takyah guna command tuk enablekan InnoDB tu. Quote Share this post Link to post Share on other sites
Farlee 0 Report post Posted March 18, 2009 OK, aku dah jumpa statement nk update data dlm 3 table skaligus (dah test dh):Code:UPDATE <table1>,<table2>,<table3> set <table1>.book_title="shamhensem",<table2>.book_title="shamhensem",<table3>.book_title="shamhensem" where <table1>.book_code="1001" and <table2>.book_code="1001" and <table3>.book_code="1001";Slamat mencuba ::icon_smile:: Quote Share this post Link to post Share on other sites
sh4m_1 0 Report post Posted March 19, 2009 waaaaa.... pandai ko...... btul la..... senang je cam ni.... hampeh tul..... aaaaaaaaaaaa.....camne ko leh dpt..?? Quote Share this post Link to post Share on other sites
Farlee 0 Report post Posted March 20, 2009 sh4m wrote:camne ko leh dpt..??Konsep "Try An Error" dalam PHPmyadmin / mysql command prompt dan pertolongan drpd pakcik Google ::icon_smile::Aku ingat fungsi UPDATE x bleh staraf fungsi INSERT dan SELECT utk multiple data atau table, tapi bila tgk formatnye sama je, aku try2 jugak. Tapi aku blum jumpa lagi format sesuai untuk fungsi DROP atau TRUNCATE dan CREATE, sbb stakat nih x bleh pakai utk multiple table / database. Quote Share this post Link to post Share on other sites
sh4m_1 0 Report post Posted March 20, 2009 thanz bro.... aku dalam bab query2 ni xberapa minat sgt la...bagus la ko slalu explore... thnz bro.. Quote Share this post Link to post Share on other sites
letsk2 0 Report post Posted August 3, 2009 wahhh...terima kasihh pakcik google.. Quote Share this post Link to post Share on other sites