dso89762 2016-09-14 10:35
浏览 61

使用php和NOT EXIST将csv导入数据库

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?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥500 火焰左右视图、视差(基于双目相机)
    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本