MySQL远程表同步_mysql同步远程数据库某个表 左手的ㄟ右手 2022-10-28 03:48 168阅读 0赞 mysql同步远程数据库某个表 final class mysql39to29 \{ private $data\_39; function data\_39() \{ $this->data\_39 = ''; $con = mysql\_connect("192.168.0.3","root","root"); if (!$con) \{ die('Could not connect: ' . mysql\_error()); \} mysql\_select\_db("epg", $con); $result = mysql\_query("SELECT \* FROM list"); while($row = mysql\_fetch\_array($result)) \{ $this->data\_39.= "( '".$row\["id"\]."', '".$row\["title"\]."', '".$row\["sheng\_id"\]."', '".$row\["channel\_id"\]."', '".$row\["default\_source\_id"\]."', '".$row\["default\_source\_id\_6007"\]."', '".$row\["source\_id"\]."', '".$row\["roms"\]."', '".$row\["clients"\]."', '".$row\["category\_id"\]."', '".$row\["alias"\]."', '".$row\["available"\]."', '".$row\["type"\]."', '".$row\["replayable"\]."', '".$row\["imgurl"\]."', '".$row\["custom"\]."', '".$row\["order"\]."', '".$row\["key\_id"\]."'),\\n"; \} mysql\_close($con); $this->data\_39 = rtrim($this->data\_39, ",\\n"); return $this->data\_39; \} function update\_29() \{ $con = mysql\_connect("192.168.0.9","analysis","123456"); if (!$con) \{ die('Could not connect: ' . mysql\_error()); \} mysql\_query("SET NAMES 'utf8'", $con); mysql\_select\_db("analysis", $con); $sql\_del = "TRUNCATE TABLE listyy;"; $result = mysql\_query($sql\_del, $con); $sql = "INSERT INTO listyy values ".$this->data\_39.";"; $result = mysql\_query($sql, $con); \} \} $ob = new mysql39to29(); $ob->data\_39(); $ob->update\_29();
还没有评论,来说两句吧...