<job version="8.21">
<!--This document documents the schema that will be used for SJA for scheduled ODBC import. Unlike other options of SJA which are cross platform, this one is not. ODBC import uses strict Win32 ODBC functions and thus is non-portable.-->
<odbcimport>
<source>
<!--Specifies the MySQL server information where to import the data-->
<tunnelinfo type="http">
<!--Specifies tunnel information. Tunneling can be either SSH/HTTP-->
<url>http://localhost/tunnel/SQLyogTunnel.php</url>
</tunnelinfo>
<host>localhost</host>
<user>root</user>
<pwd>root</pwd>
<port>3306</port>
<db>dbtoimportto</db>
</source>
<dsn type="system">
<!--Dsn section specifes information about the dsn-->
<!--Type attribute specifes the type of dsn used in the import. Possible values are *file* or *system*. Default results to system.-->
<name>hugetable</name>
<user>sarat</user>
<pwd/>
</dsn>
<import source="file"><!--Source attribute specifes whether to import data from the data source or from result returned from a query. possible values are *query* or *data*. If not specified it will default to data.--></import>
<tables>
<!--Sepcifes options for which table to import and table importing related options.-->
<table source="sourcetable1" target="targettable1" comment="Comment to be used for the target table" type="MyISAM">
<!--Describes each table that will be imported-->
<!--Source table. This table exist in the ODBC source and will be imported to MySQL.-->
<!--Target table. The source table will be imported to the target table.-->
<ddl create="yes">
<!--Specifes option for DDL statements.-->
<!--Create spcifies whether to execute DDL statement for the table.-->
<!--What happens if there is a confilct? *recreate* or *ignore*-->
<onconflict>recreate</onconflict>
<!--What happens on error? *ignore* or *abort* are the possible values.-->
<onerror>abort</onerror>
</ddl>
<dml create="yes">
<!--Specifies option for DML statements.-->
<!--Create attribute is similar to ddl *create*-->
<!--Onconflict has same meaning like *DDL* onconflict. Possible values are *ignore*, *replace*, *abort*-->
<onconflict>ignore</onconflict>
<!--OnError is similar to DDL onerror.-->
<onerror>continue</onerror>
</dml>
<columns>
<column source="col2" target="col2"/>
</columns>
</table>
<table source="srctable2" target="tgttable2">
<ddl create="yes">
<onconflict>ignore</onconflict>
<onerror>abort</onerror>
</ddl>
<dml>
<onconflict>replace</onconflict>
<onerror>continue</onerror>
</dml>
<columns>
<!--Specifies how to map each column from source to target. Each element provides details about each columns.-->
<column>
<source>col1</source>
<target>col1</target>
<type>char</type>
<length>10</length>
<default>sqlyog</default>
<primary>yes</primary>
<binary>yes</binary>
<notnull>yes</notnull>
<unsigned>no</unsigned>
<autoincr>yes</autoincr>
<zerofill>no</zerofill>
<comment>comment for something</comment>
</column>
</columns>
</table>
<table>
<source>srctable3</source>
<target>tgttable3</target>
<ddl create="no">
<onconflict>na</onconflict>
<onerror>na</onerror>
</ddl>
<dml create="yes">
<onconflict>abort</onconflict>
<onerror>continue</onerror>
</dml>
<columns>
<!--Specifies how to map each column from source to target. Each element provides details about each columns.-->
<column>
<source>col1</source>
<target>(NULL)</target>
<type>char</type>
<length>10</length>
<default>sqlyog</default>
<primary>yes</primary>
<binary>yes</binary>
<notnull>yes</notnull>
<unsigned>no</unsigned>
<autoincr>yes</autoincr>
<zerofill>no</zerofill>
<comment>comment for something</comment>
</column>
</columns>
</table>
<table>
<source>srctable4</source>
<target>tgttable4</target>
<ddl create="no">
<onconflict>na</onconflict>
<onerror>na</onerror>
</ddl>
<dml create="no">
<onconflict>na</onconflict>
<onerror>na</onerror>
</dml>
<columns>
<column source="col2" target="col2"/>
</columns>
</table>
</tables>
<smtp>
<!--Provides SMTP server information to which the email will be sent.-->
<displayname>Webyog Support</displayname>
<toemail>support@webyog.com</toemail>
<fromemail>sales@webyog.com</fromemail>
<cc>hr@webyog.com</cc>
<bcc>admin@webyog.com</bcc>
<replyemail>somename@webyog.com</replyemail>
<host>smtp.someserver.com</host>
<port>25</port>
<auth required="yes">
<user>bkavas</user>
<pwd>aaaaaa</pwd>
</auth>
<subject>Subject</subject>
</smtp>
<!--Specifies what happens if there is any error. *ignore* and *continue* are the possible values. By default, *ignore* has to be taken.-->
<onerror>ignore</onerror>
</odbcimport>
</job>
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
![txt](https://img-home.csdnimg.cn/images/20210720083642.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
共 25 条
- 1
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/3df60fc170844b9f87d639597dd528fb_qfyh_djh.jpg!1)
段子手-168
- 粉丝: 2422
- 资源: 2704
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)