insert into B
(movie_name,movie_rate,movie_director,movies_actors,movie_url,movie_types,movie_picture_name,movie_time,movie_introduce,movie_comment)
select movie_name,movie_rate,movie_director,movies_actors,movie_url,movie_types,movie_picture_name,movie_time,movie_introduce,movie_comment
from A
where not exists (select * from B
where B.movie_name=A.movie_name);
不要把主键(自增键)一起复制过去!(因为他们是唯一的)