1 // AND NOT EXISTS ( // SELECT 1 // FROM master_template_pesan cek // WHERE cek.id_data_server = ds.id // AND cek.nama = mtp.nama // ) // "; // $stmt = $pdo->prepare($sql); // $stmt->execute(); // while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { // echo "Server: {$row['tujuan_server']} | Nama: {$row['nama']} | Template: {$row['pesan']}
"; // } $sql = " INSERT INTO master_template_pesan ( id_data_server, nama, pesan, pesan_official, status_pesan, gateway_type, nama_template, backround_kwitansi, interval_koneksi_off, status_koneksi_off ) SELECT ds.id, mtp.nama, mtp.pesan, mtp.pesan_official, mtp.status_pesan, mtp.gateway_type, mtp.nama_template, mtp.backround_kwitansi, mtp.interval_koneksi_off, mtp.status_koneksi_off FROM data_server ds CROSS JOIN ( SELECT * FROM master_template_pesan WHERE id_data_server = 1 ) mtp WHERE ds.id <> 1 AND NOT EXISTS ( SELECT 1 FROM master_template_pesan cek WHERE cek.id_data_server = ds.id AND cek.nama = mtp.nama ) "; $stmt = $pdo->prepare($sql); $stmt->execute(); echo "Berhasil insert " . $stmt->rowCount() . " data.";