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> Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.