我使用这个查询来加载数据到mysql表。LOAD DATA INFILE 'E:upload.csv' REPLACE INTO TABLE ms.no_vas LINES TERMINATED BY 'n';
Upload.csv
123
456
789
000
111
222
333
现在我有另一个csv文件delete.csv
,其中内容我想从ms.no_vas
表中删除。 delete.csv 456
789
注意:这两个文件包含超过700万条记录。
是否有办法从ms.no_vas
表中删除delete.csv
上的所有值?
上传delete.csv到临时数据库,然后使用子查询删除。
的例子:
DELETE FROM ms.no_vas
WHERE ms.no_vas.value IN (SELECT value FROM temp_delete_table);
delete from ms.no_vas where yournumber = '456' and yournumber = '789'使用CSV
$handle = fopen($file,"r");
//loop through the csv file and delete into database
do {
if ($data[0]) {
mysql_query("DELETE from ms.no_vas where yournumber = '$data[])')
");
}