Re: Can not input CSV file with WKT into mysql

[lee light]

$servername = 'localhost';
$username = 'root';
$password = 'test';
$dbname = 'geometry';


$connect = mysql_connect($servername, $username , $password);


$sql = "LOAD DATA INFILE 'data.csv' INTO TABLE '$dbname' FIELDS TERMINATED BY ';'
(id , @geom ) SET geom = GeomFromText(@geom);";

$result = mysql_query($sql, $connect);

if (!$result)
echo mysql_error($connect);


Thank you!!
I have test your idea, but it doesnt work.