spires Posted April 20, 2009 Share Posted April 20, 2009 Hi guys. I'm trying to use the mysql 'BULK INSERT' to upload my csv file into my database. However, I keep getting an error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BULK INSERT test_upload FROM 'http://www.businessmobiles.com/CSV/upload.csv'' at line 1 I think it has something to do with the path, but I'm not sure what. Can any one help <?PHP include("dbconnect.php"); if (isset($_POST['submit'])) { $userfile_name = $_FILES['input']['name']; $sql = "BULK INSERT test_upload FROM 'http://www.businessmobiles.com/CSV/$userfile_name' WITH ( FIRSTROW = 2, MAXERRORS = 0, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )"; $query = mysql_query($sql) or die (mysql_error()); if ($query){ echo '1'; }else{ echo '2'; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <title>Untitled Document</title> </head> <body> <form action="test_upload.php" method="post" name="form1" enctype="multipart/form-data"> <input type="file" name="input" /> <br> <input type="submit" value="submit" name="submit" /> </form> </body> </html> Link to comment https://forums.phpfreaks.com/topic/154861-inserting-a-cvs-file-into-a-mysql-database/ Share on other sites More sharing options...
Mchl Posted April 20, 2009 Share Posted April 20, 2009 There is no such syntax as BULK INSERT... Try http://dev.mysql.com/doc/refman/5.1/en/load-data.html Link to comment https://forums.phpfreaks.com/topic/154861-inserting-a-cvs-file-into-a-mysql-database/#findComment-814510 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.