SQL agent (in SSMS) is exporting output.csv (from query). Then it moves this csv file (comma delimited) into another server, where I run php script, which is automatically importing (task scheduler) this csv file into mysql database (xampp - phpmyadmin).
try {
$pdo = new PDO("mysql:host=$databasehost;dbname=$databasename",
$databaseusername, $databasepassword,
array(
PDO::MYSQL_ATTR_LOCAL_INFILE => true,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
)
);
} catch (PDOException $e) {
die("database connection failed: ".$e->getMessage());
}
$affectedRows = $pdo->exec("
LOAD DATA LOCAL INFILE ".$pdo->quote($csvfile)." INTO TABLE `$databasetable`
FIELDS TERMINATED BY ".$pdo->quote($fieldseparator)."
LINES TERMINATED BY ".$pdo->quote($lineseparator));
echo "Loaded a total of $affectedRows records from this csv file.
";
I would like to add something like: if this value U_ScID exists dont import this value.
WHERE T3.U_CreateDate > DATEADD(hour,-12,GETDATE()-1)
AND NOT EXISTS (SELECT T5.U_ScID FROM [xxx].[dbo].[table] where T5.U_ScID = T0.U_ScId)
Do you have any idea, how should I do it?