--
"; echo "-- Copy SQL ทั้งหมดไปวางใน phpMyAdmin
"; echo "--

"; foreach($tableList as $tableName){ $query1 = "SELECT * FROM ".$_REQUEST["DBOld"].".".$tableName.""; $query2 = "SELECT * FROM ".$_REQUEST["DBNew"].".".$tableName.""; // get the result from the DB $result1 = mysql_query($query1); $result2 = mysql_query($query2); if(mysql_num_fields($result1)){ // Lists field name From MIS DB OLD unset($fieldDBOld); for ($i=0;$i"; echo "-- ตาราง : $tableName
"; echo "--

"; echo "TRUNCATE ".$_REQUEST["DBNew"].".`$tableName`;

"; unset($field); for($i=0;$i
"; echo "-- จำนวนแถวข้อมูล : ".mysql_num_rows($result1)." แถว

"; echo "-- --------------------------------------

"; } else{ echo "--
"; echo "-- $tableName
"; echo "--

"; echo "-- ไม่พบ ตาราง $tableName ในฐานข้อมูล ".$_REQUEST["DBOld"]."

"; echo "-- --------------------------------------

"; } } } } ?>

MIS MIGRATE