Load Data local infile liest nur 0.00000 ein

 

<?php

define('HOST', '.....');  
define('USER', '......');  
define('PASS', '........');  
define('DBNAME', '..........');  

$connection = mysql_connect(HOST, USER, PASS);

if (!$connection) {
	die("can not connect to the server!<br/>");  
} else {

	$rdb = mysql_select_db(DBNAME);
	if (!$rdb) {
		die("The " . DBNAME . "database could not be selected");  
	} else {
		// insert to the student table query
		$insert_query = "LOAD DATA LOCAL INFILE 'test.csv'   
                INTO table student4
		FIELDS TERMINATED BY ';'  
                LINES TERMINATED BY '\n'  
                (Datum,Uhrzeit,Werteins,Wertzwei,Wertdrei, @date, @time, @decimal, @decimal, @decimal) 
		";  
		
		# NOT NULL muss hier noch irgendwo vermerkt werden....

		if (!mysql_query($insert_query, $connection)) {
			echo "Can't insert student record : " . mysql_error($connection);  
		} else {
			echo "You have successfully insert records into student table";  
		}
	}
}
mysql_close($connection);
?>