csv文件转为mysql的表_将CSV文件数据导入MySQL表

I am inserting record from CSV file to MySQL table; if any record already exists update that record and insert other records and if there is no match of the record insert all records.

Here is my code

$connect = mysql_connect('localhost','root','root');

if (!$connect) {

die('Could not connect to MySQL: ' . mysql_error());

}

$cid =mysql_select_db('bizin490_devcredit',$connect);

define('CSV_PATH', '/home/ubc/Documents/');

$csv_file = CSV_PATH . "test.csv";

$csvfile = fopen($csv_file, 'r');

$theData = fgets($csvfile);

$i = 0;

while (!feof($csvfile)) {

$csv_data[] = fgets($csvfile, 1024);

$csv_array = explode(",", $csv_data[$i]);

$insert_csv = array();

$insert_csv['name'] = $csv_array[0];

$insert_csv['email'] = $csv_array[1];

$query = mysql_query("select name from test where name='" . $insert_csv['name'] . "'");

$count = mysql_num_rows($query);

if ($count == 0) {

$query = "INSERT INTO test(name,email)VALUES('" . $insert_csv['name'] . "','" . $insert_csv['email'] . "')";

$n = mysql_query($query, $connect);

} else {

$sql = "update test set email='".$insert_csv['email']."'";

//echo "

";print_r($sql);

$qu = mysql_query($sql);

echo "

";print_r($_POST);

}

$i++;

//die;

}

fclose($csvfile);

echo "File data successfully imported to database!!";

mysql_close($connect);

?>

解决方案

Something like:

LOAD DATA INFILE '/home/ubc/Documents/test.csv'

REPLACE

INTO TABLE `test`

(name, email)