Mysql碰到的一些命令与错误

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.

set SQL_SAFE_UPDATES = 0;

load data local infile '/Users/ltc/Downloads/test.csv' 
into table `test` 
fields terminated by ',' optionally enclosed by '"' escaped by '"' 
lines terminated by '\n';

Error Code: 13. Can't get stat of '/Users/ltc/Downloads/test.csv' (Errcode: 13 - Permission denied)

truncate table tablename;