insert into select from

从一个表中取数据放到另一个表

2016-11-30 17:45:40 catherine

INSERT INTO shaohualee.articles(title,keyword,desc,html_content,user_id,cate_id,created_at,updated_at) 
SELECT p.post_title,p.post_title,p.post_title, p.post_content,1,6,p.post_date, p.post_date FROM lish.wp_posts AS p LEFT JOIN lish.wp_term_relationships as t ON t.object_id = p.id WHERE p.post_status=’publish’ AND t.term_taxonomy_id = 1

分类: web

标签: mysql

微信号：腾讯云折扣返现

技术讨论QQ群： 863102326

作者: catherine

搜索

study ab amap apache apahe awk aws bat centos CFS chrome cmd cnpm composer consul crontab css curl cygwin devops di docker docker,docker-compose ethereum excel fiddler fluentd framework front-end git gitgui github glide go golang gorm grafana gzip ioc item2 iterm2 javascript jenkins jsonp kafka laradock laravel larval linux liunux log mac mac, wi-fi macos magento mariaDB minikube mongoDB msp mysql netbeans nginx nodejs nohup npm nsq oracle php php-fpm php7 phpstorm php扩展 Protobuf python redis scp server shell soap socket socket5 sql sre ssdb ssh ssl study sublime swift system td-agent uml v2ray vagrant vagrnat vim vpn vue vue.js webpack webrtc websocket webtatic windows windows7 word wps xdebug yarn yii2 yum zookeeper 世界国家互联网以太坊分类前端小程序打印机排序算法搞笑权限粤语缓存网络虚拟机视频设计模式项目管理