note 114636 added to mysqli.query

From: Date: Fri, 14 Mar 2014 19:00:53 +0000
Subject: note 114636 added to mysqli.query
Groups: php.notes 
Request: Send a blank email to php-notes+get-198894@lists.php.net to get a copy of this message
For those using with replication enabled on their servers, add a mysqli_select_db() statement before any data modification queries. MySQL replication does not handle statements with db.table the same and will not replicate to the slaves if a scheme is not selected before. Found out after days of resetting master and slaves on another site http://www.linuxquestions.org/questions/linux-server-73/mysql-5-1-not-replicating-properly-with-slave-823296/ ---- Server IP: 192.41.45.150 Probable Submitter: 97.77.105.2 ---- Manual Page -- http://php.net/manual/en/mysqli.query.php Edit -- https://master.php.net/note/edit/114636 Del: integrated -- https://master.php.net/note/delete/114636/integrated Del: useless -- https://master.php.net/note/delete/114636/useless Del: bad code -- https://master.php.net/note/delete/114636/bad+code Del: spam -- https://master.php.net/note/delete/114636/spam Del: non-english -- https://master.php.net/note/delete/114636/non-english Del: in docs -- https://master.php.net/note/delete/114636/in+docs Del: other reasons-- https://master.php.net/note/delete/114636 Reject -- https://master.php.net/note/reject/114636 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#198894) next »