Import Any CSV into mySQL queries

gistfile1.php

<?php
$file      = 'C:\\data.csv';
$fields    = array();
$sqlOutput = '';

if($f = fopen($file, 'r'))
{
	$fields = fgetcsv($f);
	fclose($f);
	if (!empty($fields))
	{
		$sqlOutput .= "DROP TABLE IF EXISTS `import_tmp`;\n\n";
		$sqlOutput .= "CREATE TABLE `import_tmp` (";
		$sqlOutput .= '`'.implode("` mediumtext NOT NULL,\n`",$fields).'` mediumtext NOT NULL'."\n";
		$sqlOutput .= ") ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\n";
		$sqlOutput .= "ALTER TABLE `import_tmp` ADD `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;\n\n";
		$sqlOutput .= "LOAD DATA LOCAL INFILE '$file' INTO TABLE import_tmp FIELDS TERMINATED BY ',' ENCLOSED BY '\'' LINES TERMINATED BY '\\n' (`".implode("`,`",$fields)."`);\n\n";
		$sqlOutput .= "DELETE FROM `import_tmp` WHERE `id` = 1;\n\n";
	}
	echo $sqlOutput;
}

?>