情景:需要把A表的数据导入同一个数据库的B表中
语句:
> insert into
> donews(Url,title,keywords,description,content,create_time,crawler_time,site,first_img_src)
> SELECT
> Url,title,keywords,description,content,create_time,crawler_time,site,first_img_src
> FROM bucket141205 where TO_DAYS(NOW()) - TO_DAYS(create_time) <= 30
> and Site='Donews'
根据需要控制字段,
可能会出现error:
ERROR 1206 (HY000): The total number of locks exceeds the lock table size
需要调整Mysql配置文件my.cnf
中
nnodb_buffer_pool_size = 800M
根据服务器内存大小设置参数。