mysql一张表数据导入到另一张表

问题：mysql如何将数据从一张表导入到另一张表
方法：
insert into searchs (user_id, user_ip, created, searchword) select user_id, user_ip, created, website from views where operate='search';