LOAD DATA INFILE 'data.csv' INTO TABLE table_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;SELECT p.id post_id,a.id author_id,a.name author_name
author_user au
INNER JOIN posts p ON au.author_id=p.author_id
LEFT JOIN post_user pu ON au.user_id=p.user_id and p.id=pu.post_id
INNER JOIN authors a ON p.author_id=a.id
WHERE
user_id=2
HAVING
pu.id IS NULL