<pre><code>
$databasehost = "localhost";
$databasename = "giris";
$databasetable = "xxx";
$databaseusername="yyy";
$databasepassword = "zzz";
$fieldseparator = ";";
$lineseparator = "n";
$csvfile = 'plandosyalari/planlama.csv';

if(!file_exists($csvfile)) {
    die("File not found. Make sure you specified the correct path.");
}

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)
       (PO, Material, Batch, Qty, @SchStartdate, SchStarttime, SchFinishdate, SchFinishtime, ActStartdate, ActStarttime, ActFinishdate, ActFinishtime, Machine)
        SET SchStartdate = STR_TO_DATE('@SchStartdate', '%d-%m-%Y'));
</code></pre>