<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ENTJ1的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ENTJ1</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ENTJ1]]></copyright><item><title><![CDATA[mysql用中间表,加索引,从一张表中特定字段内容导入另一张表特定字段内容]]></title><link>https://blog.youkuaiyun.com/ENTJ1/article/details/105235996</link><guid>https://blog.youkuaiyun.com/ENTJ1/article/details/105235996</guid><author>ENTJ1</author><pubDate>Wed, 01 Apr 2020 00:06:11 +0800</pubDate><description><![CDATA[表a:edu_app_school_info(字段area_id)
--------表b:edu_app_xq_school_class(字段area_id)
匹配字段
表a:			xq_id
表b:			school_id
表a:数据量6000条
表b:数据量十万条

创建中间表
create table xq_area (
area_id varchar (192),
xq_id varcha...]]></description><category></category></item><item><title><![CDATA[linux,将一个表只复制希望的列插入到另一个已经存在的表对应的列中]]></title><link>https://blog.youkuaiyun.com/ENTJ1/article/details/105214913</link><guid>https://blog.youkuaiyun.com/ENTJ1/article/details/105214913</guid><author>ENTJ1</author><pubDate>Tue, 31 Mar 2020 09:25:23 +0800</pubDate><description><![CDATA[eg:
 库:interface_data -&gt; edu_center_main
 表:aaa     	             bbb

 XXJGID     school_id
 ID          openid
 xm           xm
 xb           xb
 sfzjlx      sfzjlx
 sfzjh       sfzjh
 csrq    ...]]></description><category></category></item><item><title><![CDATA[kettle使用windows的mysql->linux的mysql]]></title><link>https://blog.youkuaiyun.com/ENTJ1/article/details/105214817</link><guid>https://blog.youkuaiyun.com/ENTJ1/article/details/105214817</guid><author>ENTJ1</author><pubDate>Tue, 31 Mar 2020 09:14:21 +0800</pubDate><description><![CDATA[##KETTLE使用,windows的mysql-&gt;linux的mysql

在kettle解压包下的lib目录下分别加入两个系统的mysql对应版本的jdbc驱动
需要对应数据库的  服务器主机号,端口号,用户,密码,是直接连到对应mysql的database中
DB连接–共享(对应的两个数据库操作)
主对象树和核心对象数可以交替探查
选项:命名参数:characterEncoding,值...]]></description><category></category></item></channel></rss>