首页 / MYSQL / MYSQL实时触发SQL SERVER 实例

MYSQL实时触发SQL SERVER 实例

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MYSQL实时触发SQL SERVER 实例，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含17631字，纯文字阅读大概需要26分钟。

内容图文

以下给出如何实现MYSQL数据表更新实时触发sql server里面对应表的增删改操作，首先，增加原来的mysql的表的触发器，包括以下三个：

插入数据：

delimiter ||
DROP TRIGGER IF EXISTS t_afterinsert_on_accounts ||
CREATE TRIGGER t_afterinsert_on_accounts
AFTER INSERT ON sugarcrm642ce.accounts
FOR EACH ROW
BEGIN
insert into sugarcrm642cebackup.accountsbackup
(`id`,
`name`,
`date_entered`,
`date_modified`,
`modified_user_id`,
`created_by`,
`description`,
`deleted`,
`assigned_user_id`,
`account_type`,
`industry`,
`annual_revenue`,
`phone_fax`,
`billing_address_street`,
`billing_address_city`,
`billing_address_state`,
`billing_address_postalcode`,
`billing_address_country`,
`rating`,
`phone_office`,
`phone_alternate`,
`website`,
`ownership`,
`employees`,
`ticker_symbol`,
`shipping_address_street`,
`shipping_address_city`,
`shipping_address_state`,
`shipping_address_postalcode`,
`shipping_address_country`,
`parent_id`,
`sic_code`,
`campaign_id`,
`BehaviorType`) values(new.id,new.name,new.date_entered,new.date_modified,new.modified_user_id,new.created_by,new.description,new.deleted,
new.assigned_user_id,new.account_type,new.industry,new.annual_revenue,new.phone_fax,new.billing_address_street,new.billing_address_city,new.billing_address_state,
new.billing_address_postalcode,new.billing_address_country,new.rating,new.phone_office,new.phone_alternate,new.website,new.ownership,new.employees,new.ticker_symbol,
new.shipping_address_street,new.billing_address_city,new.shipping_address_state,new.shipping_address_postalcode,new.shipping_address_country,new.parent_id,
new.sic_code,new.campaign_id,'I');
END||

更新触发器

delimiter ||
DROP TRIGGER IF EXISTS t_afterupdate_on_accounts ||
CREATE TRIGGER t_afterupdate_on_accounts
AFTER update ON sugarcrm642ce.accounts
FOR EACH ROW
BEGIN
insert into sugarcrm642cebackup.accountsbackup
(`id`,
`name`,
`date_entered`,
`date_modified`,
`modified_user_id`,
`created_by`,
`description`,
`deleted`,
`assigned_user_id`,
`account_type`,
`industry`,
`annual_revenue`,
`phone_fax`,
`billing_address_street`,
`billing_address_city`,
`billing_address_state`,
`billing_address_postalcode`,
`billing_address_country`,
`rating`,
`phone_office`,
`phone_alternate`,
`website`,
`ownership`,
`employees`,
`ticker_symbol`,
`shipping_address_street`,
`shipping_address_city`,
`shipping_address_state`,
`shipping_address_postalcode`,
`shipping_address_country`,
`parent_id`,
`sic_code`,
`campaign_id`,
`BehaviorType`) values(new.id,new.name,new.date_entered,new.date_modified,new.modified_user_id,new.created_by,new.description,new.deleted,
new.assigned_user_id,new.account_type,new.industry,new.annual_revenue,new.phone_fax,new.billing_address_street,new.billing_address_city,new.billing_address_state,
new.billing_address_postalcode,new.billing_address_country,new.rating,new.phone_office,new.phone_alternate,new.website,new.ownership,new.employees,new.ticker_symbol,
new.shipping_address_street,new.billing_address_city,new.shipping_address_state,new.shipping_address_postalcode,new.shipping_address_country,new.parent_id,
new.sic_code,new.campaign_id,'U');
END||

删除触发器

delimiter ||
DROP TRIGGER IF EXISTS t_afterdelete_on_accounts ||
CREATE TRIGGER t_afterdelete_on_accounts
AFTER delete ON sugarcrm642ce.accounts
FOR EACH ROW
BEGIN
insert into sugarcrm642cebackup.accountsbackup
(`id`,
`name`,
`date_entered`,
`date_modified`,
`modified_user_id`,
`created_by`,
`description`,
`deleted`,
`assigned_user_id`,
`account_type`,
`industry`,
`annual_revenue`,
`phone_fax`,
`billing_address_street`,
`billing_address_city`,
`billing_address_state`,
`billing_address_postalcode`,
`billing_address_country`,
`rating`,
`phone_office`,
`phone_alternate`,
`website`,
`ownership`,
`employees`,
`ticker_symbol`,
`shipping_address_street`,
`shipping_address_city`,
`shipping_address_state`,
`shipping_address_postalcode`,
`shipping_address_country`,
`parent_id`,
`sic_code`,
`campaign_id`,
`BehaviorType`) values(old.id,old.name,old.date_entered,old.date_modified,old.modified_user_id,old.created_by,old.description,old.deleted,
old.assigned_user_id,old.account_type,old.industry,old.annual_revenue,old.phone_fax,old.billing_address_street,old.billing_address_city,old.billing_address_state,
old.billing_address_postalcode,old.billing_address_country,old.rating,old.phone_office,old.phone_alternate,old.website,old.ownership,old.employees,old.ticker_symbol,
old.shipping_address_street,old.billing_address_city,old.shipping_address_state,old.shipping_address_postalcode,old.shipping_address_country,old.parent_id,
old.sic_code,old.campaign_id,'D');
END||

上面必须增加behaviortype字段，因为如果是I代表插入，U代表更新，D代表删除，接着增加mysql的备份表，专门记录这三种操作。

CREATE TABLE `accountsbackup` (
  `id` char(36) NOT NULL,
  `name` varchar(150) DEFAULT NULL,
  `date_entered` datetime DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `modified_user_id` char(36) DEFAULT NULL,
  `created_by` char(36) DEFAULT NULL,
  `description` text,
  `deleted` tinyint(1) DEFAULT NULL,
  `assigned_user_id` char(36) DEFAULT NULL,
  `account_type` varchar(50) DEFAULT NULL,
  `industry` varchar(50) DEFAULT NULL,
  `annual_revenue` varchar(100) DEFAULT NULL,
  `phone_fax` varchar(100) DEFAULT NULL,
  `billing_address_street` varchar(150) DEFAULT NULL,
  `billing_address_city` varchar(100) DEFAULT NULL,
  `billing_address_state` varchar(100) DEFAULT NULL,
  `billing_address_postalcode` varchar(20) DEFAULT NULL,
  `billing_address_country` varchar(255) DEFAULT NULL,
  `rating` varchar(100) DEFAULT NULL,
  `phone_office` varchar(100) DEFAULT NULL,
  `phone_alternate` varchar(100) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `ownership` varchar(100) DEFAULT NULL,
  `employees` varchar(10) DEFAULT NULL,
  `ticker_symbol` varchar(10) DEFAULT NULL,
  `shipping_address_street` varchar(150) DEFAULT NULL,
  `shipping_address_city` varchar(100) DEFAULT NULL,
  `shipping_address_state` varchar(100) DEFAULT NULL,
  `shipping_address_postalcode` varchar(20) DEFAULT NULL,
  `shipping_address_country` varchar(255) DEFAULT NULL,
  `parent_id` char(36) DEFAULT NULL,
  `sic_code` varchar(10) DEFAULT NULL,
  `campaign_id` char(36) DEFAULT NULL,
  `BehaviorType` varchar(45) DEFAULT NULL,
  `ExecutingState` varchar(45) DEFAULT NULL,
  `ModificationTime` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

这个表如无意外，ID不要设置成为唯一索引，因为本身就存在多条同一个记录的更改。接下来在sql server建立对应的表。

USE [SugarCRMDB]
GO

/****** Object:  Table [dbo].[account]    Script Date: 2015/6/24 13:49:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo]. [account](
                 [id] [char] (36) NOT NULL,
                 [name] [varchar] (150) NULL,
                 [date_entered] [datetime] NULL,
                 [date_modified] [datetime] NULL,
                 [modified_user_id] [char] (36) NULL,
                 [created_by] [char] (36) NULL,
                 [description] [text] NULL,
                 [deleted] [smallint] NULL,
                 [assigned_user_id] [char] (36) NULL,
                 [account_type] [varchar] (50) NULL,
                 [industry] [varchar] (50) NULL,
                 [annual_revenue] [varchar] (100) NULL,
                 [phone_fax] [varchar] (100) NULL,
                 [billing_address_street] [varchar] (150) NULL,
                 [billing_address_city] [varchar] (100) NULL,
                 [billing_address_state] [varchar] (100) NULL,
                 [billing_address_postalcode] [varchar] (20) NULL,
                 [billing_address_country] [varchar] (255) NULL,
                 [rating] [varchar] (100) NULL,
                 [phone_office] [varchar] (100) NULL,
                 [phone_alternate] [varchar] (100) NULL,
                 [website] [varchar] (255) NULL,
                 [ownership] [varchar] (100) NULL,
                 [employees] [varchar] (10) NULL,
                 [ticker_symbol] [varchar] (10) NULL,
                 [shipping_address_street] [varchar] (150) NULL,
                 [shipping_address_city] [varchar] (100) NULL,
                 [shipping_address_state] [varchar] (100) NULL,
                 [shipping_address_postalcode] [varchar] (20) NULL,
                 [shipping_address_country] [varchar] (255) NULL,
                 [parent_id] [char] (36) NULL,
                 [sic_code] [varchar] (10) NULL,
                 [campaign_id] [char] (36) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

最后建立sql server存储过程，这边尤其要注意的是要rtrim mysql char类型，因为sql server对这个是完全填充的，如果有多余空格插入会报错，同时要定义为别名，因为在下面的插入是根据别名字段来的。

USE [SugarCRMDB]
GO
/****** Object:  StoredProcedure [dbo].[trigger_account]    Script Date: 2015/6/24 14:38:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo]. [trigger_account]
as
    --insert into sugarcrmtablebackup(id,name) select * from openquery(MySql, 'select id,name from sugarcrmtablebackup where NOT ISNULL(ExecutingState) ')
                
                 --插入BehaviorState为I的记录
                 --insert into account(id,name,date_entered,date_modified,modified_user_id,created_by,[description],deleted,assigned_user_id,account_type,industry,annual_revenue,phone_fax,billing_address_street,billing_address_city,billing_address_state,billing_address_postalcode,billing_address_country,rating,phone_office,phone_alternate,website,[ownership],employees,ticker_symbol,shipping_address_street,shipping_address_city,shipping_address_state,shipping_address_postalcode,shipping_address_country,parent_id,sic_code,campaign_id)
                                 --select * from openquery(MySql, 'select id,name,date_entered,date_modified,modified_user_id,created_by,description,deleted,assigned_user_id,account_type,industry,annual_revenue,phone_fax,billing_address_street,billing_address_city,billing_address_state,billing_address_postalcode,billing_address_country,rating,phone_office,phone_alternate,website,ownership,employees,ticker_symbol,shipping_address_street,shipping_address_city,shipping_address_state,shipping_address_postalcode,shipping_address_country,parent_id,sic_code,campaign_id from sugarcrm642cebackup.accountsbackup where  ISNULL(ExecutingState) and BehaviorType=''I''') 

                 insert into account( id ,name, date_entered,date_modified ,modified_user_id, created_by,[description] ,deleted, assigned_user_id,account_type ,industry, annual_revenue,phone_fax ,billing_address_street, billing_address_city,billing_address_state ,billing_address_postalcode, billing_address_country,rating ,phone_office, phone_alternate,website ,[ownership], employees,ticker_symbol ,shipping_address_street, shipping_address_city,shipping_address_state ,shipping_address_postalcode, shipping_address_country,parent_id ,sic_code, campaign_id)
                                 select * from openquery(MySql , 'select rtrim(id), name,date_entered,date_modified,rtrim(modified_user_id),rtrim(created_by),description,deleted,rtrim(assigned_user_id),account_type,industry,annual_revenue,phone_fax,billing_address_street,billing_address_city,billing_address_state,billing_address_postalcode,billing_address_country,rating,phone_office,phone_alternate,website,ownership,employees,ticker_symbol,shipping_address_street,shipping_address_city,shipping_address_state,shipping_address_postalcode,shipping_address_country,rtrim(parent_id),sic_code,rtrim(campaign_id) from sugarcrm642cebackup.accountsbackup where  ISNULL(ExecutingState) and BehaviorType=''I''')  


                 update openquery (MySql, 'select * from sugarcrm642cebackup.accountsbackup where  ISNULL(ExecutingState) and BehaviorType=''i''') set ExecutingState='D' ,ModificationTime= getdate()


                 --删除BehaviorState为U的记录
                 if object_id ('tempdb..#temp') is not null Begin
    drop table #temp
End
  
    select * into #temp from openquery( MySql, 'select rtrim(id),name from sugarcrm642cebackup.accountsbackup where  ISNULL(ExecutingState) and BehaviorType=''D''')

                 declare @count int --变量定义
                 set @count =(select count(*) from #temp );

                 if @count >0 begin
                

                 delete from account where id in (select rtrim(id ) from #temp)

                 update openquery (MySql, 'select * from sugarcrm642cebackup.accountsbackup where  ISNULL(ExecutingState) and BehaviorType=''D''') set ExecutingState='D' ,ModificationTime= getdate()

                 End
                 --更新BehaviorState为D的记录
                 if object_id ('tempdb..#temp1') is not null Begin
    drop table #temp1
End
  
     select * into #temp1 from openquery( MySql, 'select rtrim(id) id, name,date_entered,date_modified,rtrim(modified_user_id) modified_user_id,rtrim(created_by) created_by,description,deleted,rtrim(assigned_user_id) assigned_user_id,account_type,industry,annual_revenue,phone_fax,billing_address_street,billing_address_city,billing_address_state,billing_address_postalcode,billing_address_country,rating,phone_office,phone_alternate,website,ownership,employees,ticker_symbol,shipping_address_street,shipping_address_city,shipping_address_state,shipping_address_postalcode,shipping_address_country,rtrim(parent_id) parent_id,sic_code,rtrim(campaign_id) campaign_id from sugarcrm642cebackup.accountsbackup where  ISNULL(ExecutingState) and BehaviorType=''U''')
                 declare @count2 int --变量定义
                  set @count2 =(select count(*) from #temp1 )
                
                 if @count2 >0 begin
                
                 if  EXISTS (SELECT * FROM account   a, #temp1 b WHERE a.ID = b.ID )

                 --declare @a int
                 update account   set  id=t .id, name=t .name, date_entered=t .date_entered, date_modified=t .date_modified, modified_user_id=t .modified_user_id, created_by=t .created_by,
                 [description]=t .[description], deleted=t .deleted, assigned_user_id=t .assigned_user_id, account_type=t .account_type, industry=t .industry, annual_revenue=t .annual_revenue,
                 phone_fax=t .phone_fax, billing_address_street=t .billing_address_street, billing_address_city=t .billing_address_city, billing_address_state=t .billing_address_state,
                 billing_address_postalcode =t. billing_address_postalcode,billing_address_country =t. billing_address_country,rating =t. rating,phone_office =t. phone_office,
                 phone_alternate=t .phone_alternate, website=t .website, [ownership]=t .[ownership], employees=t .employees, ticker_symbol=t .ticker_symbol, shipping_address_street=t .shipping_address_street,
                 shipping_address_city =t. shipping_address_city,shipping_address_state =t. shipping_address_state,shipping_address_postalcode =t. shipping_address_postalcode,
                 shipping_address_country =t. shipping_address_country,parent_id =t. parent_id,sic_code =t. sic_code,campaign_id =t. campaign_id from   account inner join(   select id ,name, date_entered,date_modified ,modified_user_id, created_by,[description] ,deleted, assigned_user_id,account_type ,industry, annual_revenue,phone_fax ,billing_address_street, billing_address_city,billing_address_state ,billing_address_postalcode, billing_address_country,rating ,phone_office, phone_alternate,website ,[ownership], employees,ticker_symbol ,shipping_address_street, shipping_address_city,shipping_address_state ,shipping_address_postalcode, shipping_address_country,parent_id ,sic_code, campaign_id from #temp1) t on t. id=account .id
                
                  if EXISTS (SELECT * FROM account   a, #temp1 b WHERE a.ID != b.ID )

                   if object_id ('tempdb..#temp2') is not null Begin
    drop table #temp2
                 end
                  select * into #temp2 from #temp1 a where a. id not in (select id from account )

                 insert into account ( id ,name, date_entered,date_modified ,modified_user_id, created_by,[description] ,deleted, assigned_user_id,account_type ,industry, annual_revenue,phone_fax ,billing_address_street, billing_address_city,billing_address_state ,billing_address_postalcode, billing_address_country,rating ,phone_office, phone_alternate,website ,[ownership], employees,ticker_symbol ,shipping_address_street, shipping_address_city,shipping_address_state ,shipping_address_postalcode, shipping_address_country,parent_id ,sic_code, campaign_id)
                                 select   t .id ,t. name,t .date_entered, t.date_modified ,t. modified_user_id,t .created_by, t.[description] ,t. deleted,t .assigned_user_id, t.account_type ,t. industry,t .annual_revenue, t.phone_fax ,t. billing_address_street,t .billing_address_city, t.billing_address_state ,t. billing_address_postalcode,t .billing_address_country, t.rating ,phone_office, t.phone_alternate ,t. website,t .[ownership], t.employees ,t. ticker_symbol,t .shipping_address_street, t.shipping_address_city ,t. shipping_address_state,t .shipping_address_postalcode, t.shipping_address_country ,t. parent_id,t .sic_code, t.campaign_id from #temp2 t
                                  --inner join  ( select id from account) a on a.id !=t.id

                 if not exists (SELECT * FROM account  a,#temp1 b WHERE a .ID = b .ID) and not exists (SELECT * FROM account   a, #temp1 b WHERE a.ID != b.ID )
                  insert into account ( id ,name, date_entered,date_modified ,modified_user_id, created_by,[description] ,deleted, assigned_user_id,account_type ,industry, annual_revenue,phone_fax ,billing_address_street, billing_address_city,billing_address_state ,billing_address_postalcode, billing_address_country,rating ,phone_office, phone_alternate,website ,[ownership], employees,ticker_symbol ,shipping_address_street, shipping_address_city,shipping_address_state ,shipping_address_postalcode, shipping_address_country,parent_id ,sic_code, campaign_id)
                                 select   t .id ,t. name,t .date_entered, t.date_modified ,t. modified_user_id,t .created_by, t.[description] ,t. deleted,t .assigned_user_id, t.account_type ,t. industry,t .annual_revenue, t.phone_fax ,t. billing_address_street,t .billing_address_city, t.billing_address_state ,t. billing_address_postalcode,t .billing_address_country, t.rating ,phone_office, t.phone_alternate ,t. website,t .[ownership], t.employees ,t. ticker_symbol,t .shipping_address_street, t.shipping_address_city ,t. shipping_address_state,t .shipping_address_postalcode, t.shipping_address_country ,t. parent_id,t .sic_code, t.campaign_id from #temp1 t
                 


                 update openquery (MySql, 'select * from sugarcrm642cebackup.accountsbackup where  ISNULL(ExecutingState) and BehaviorType=''U''') set ExecutingState='D' ,ModificationTime= getdate()
                  End
    --delete from sql_tem
    --delete openquery(MySql, 'SELECT * FROM sugarcrmtablebackup')

最后再开启sql server代理，因为本身这个需要计划任务每秒去monitor这个mysql变化，因为sql server这边只能设置10秒更新一次，那这边就只能如此，如果要看是否成功，可以右击该计划任务查看历史记录。

MYSQL实时触发SQL SERVER 实例

标签：

本文系统来源：http://blog.csdn.net/orichisonic/article/details/46798913

内容总结

以上是互联网集市为您收集整理的MYSQL实时触发SQL SERVER 实例全部内容，希望文章能够帮你解决MYSQL实时触发SQL SERVER 实例所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/451349.html

来源：【匿名】

【上一篇】配置远程连接mysql数据库 Connect to remote mysql database 【下一篇】使用函数递归实现基于php和MySQL的动态树型菜单

更多 ►

【MYSQL实时触发SQL SERVER 实例】教程文章相关的互联网学习教程文章

mysql事务处理用法与实例详解【代码】

来源:转载 MySQL的事务支持不是绑定在MySQL服务器本身，而是与存储引擎相关1.MyISAM：不支持事务，用于只读程序提高性能 2.InnoDB：支持ACID事务、行级锁、并发 3.Berkeley DB：支持事务一个事务是一个连续的一组数据库操作，就好像它是一个单一的工作单元进行。换言之，永远不会是完整的事务，除非该组内的每个单独的操作是成功的。如果在事务的任何操作失败，则整个事务将失败。实际上，会俱乐部许多SQL查询到一个组中，将执行...

php+mysql实现数据库随机重排实例

本文实例实现了php+mysql数据库随机重排的方法，可将表中的所有数据随机读出来一次之后再进行随机保存到另一个表，从而达到了记录随机的功能。主要实现代码如下：复制代码代码如下:<?php //数据库连接就不写在这里面了 $s = isset( $_GET[‘s‘] )?$_GET[‘s‘]:0; $e = isset( $_GET[‘e‘])?$_GET[‘e‘]:50; $count =85000; if( $s < $count ) { $sql = "select * from 表前缀_info where isget =0 order by id desc limit $s...

Mysql备份还原数据库之mysqldump实例及参数详细说明【代码】

我们在运营项目的过程中肯定会遇到备份数据库，还原数据库的情况，我们一般用一下两种方式来处理：1.使用into outfile 和 load data infile导入导出备份数据这种方法的好处是，导出的数据可以自己规定格式，并且导出的是纯数据，不存在建表信息，你可以直接导入另外一个同数据库的不同表中，相对于mysqldump比较灵活机动。我们来看下面的例子：（1）下面的mysql命令是把select的mytable表中的数据导出到/home/db_bak2012文件。sele...

Spring4 MVC+Hibernate4+MySQL+Maven使用注解集成实例【代码】【图】

在本教程中，我们将使用基于注解的配置集成Spring和Hibernate。我们将开发包含表单要求用户输入一个简单的CRUD为导向Web应用程序，使用Hibernate保存输入的数据到 MySQL 数据库，从数据库和更新检索记录或删除它们在事务中，全部采用注解配置。使用以下技术：Spring 4.0.6.RELEASEHibernate Core 4.3.6.Finalvalidation-api 1.1.0.Finalhibernate-validator 5.1.3.FinalMySQL Server 5.6Maven 3JDK 1.7Tomcat 8.0.21Eclipse JUNO ...

9 低级发现Mysql多实例【代码】【图】

主要讲item原型启动mysql多实例3307 3308[root@linux-node2 ~]# cp /etc/my.cnf /etc/my3307.cnf [root@linux-node2 ~]# cp /etc/my.cnf /etc/my3308.cnf 原始的修改内容如下[root@linux-node2 ~]# grep ‘^[a-Z]‘ /etc/my3308.cnf datadir=/data/3308 socket=/data/3308/mysql.sock symbolic-links=0 port=3308 log-error=/data/3308/mariadb.log pid-file=/data/3308/mariadb.pid[root@linux-node2 ~]# grep ‘^[a-Z]‘ /etc...

highcharts实例教程一：结合php与mysql生成折线图【图】

Highcharts是一款纯javascript和html5编写的图表库，不仅几乎能兼容所有pc浏览器，而且对ios和android手机端的兼容性也不错，它能够很简单便捷的在Web网站或Web应用中添加交互性的图表，Highcharts目前支持直线图、折线图、面积图、柱状图、饼图、散点图等多达28种不同类型的图表，还支持3D立体图表的生成，可以满足你对Web图表的任何需求！而且Highcharts对学习者、非商业机构是免费使用的。案例场景：要求针对技术cto网站，...

MySQL Replication主主复制—（实例）【代码】

Step1:主主节点/ect/my.cnf的配置系统版本：CentOS-6.5-x86_64##node1 [mysqld] basedir=/usr/local/mysql datadir=/var/lib/mysql port=3306 socket=/var/lib/mysql/mysql.sockserver-id=1 log-bin=/data/mysql/binlog/mysql-bin relay-log=/data/mysql/binlog/mysql-relay-bin binlog-cache-size=10m sync-binlog=1 expire_logs_days=30 replicate-wild-do-table=testdb1.% replicate-wild-do-table=testdb2.%##node2 [mysqld] b...

spring mvc+ibatis+mysql的组合框架入门实例demo源码下载【图】

原文：spring mvc+ibatis+mysql的组合框架入门实例demo源码下载源代码下载地址：http://www.zuidaima.com/share/1550463678958592.htm spring mvc+ibatis+mysql的组合框架实例首页 http://localhost:端口/项目/index.jsp 添加用户添加地址项目截图 jar包截图原文：http://blog.csdn.net/springmvc_springdata/article/details/43602255

MySQL索引优化实例说明

下面分别创建三张表，并分别插入1W条简单的数据用来测试，详情如下：[1] test_a 有主键但无索引 CREATE TABLE `test_a` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `content` text NOT NULL, `number` int(10) unsigned NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8; [2] test_b 有主键和单列索引 CREATE TABLE `test_b` ( `id` int(10) uns...

(笔记)Mysql实例：建库建表并插入数据2

drop database if exists school; // 如果存在SCHOOL则删除create database school; // 建立库SCHOOLuse school; // 打开库SCHOOLcreate table teacher( // 建立表TEACHER id int(3) auto_increment not null primary key, name char(10) not null, address varchar(50) default ‘‘深圳‘‘, year date); // 建表结束// 以下为插入字段insert into teacher values(‘‘‘‘,‘‘glchengang‘‘,‘‘深圳一中‘‘...

mysql分区及实例演示【代码】

一、为什么要分区？需求：大数据。解决方案：分而治之，更细一点即为。将大表和大索引分为一个更小的操作单元在mysql中，分区允许将表、索引和索引编排表细分为更小的单元。分区后，每个分区有自己单独的名称。对于DBA来讲，这些分区可以统一管理，也可以分开管理。但是对于应用程序来讲，分区的表和没有分区的表示一样的。换句话来讲，分区对于应用是透明的，只是数据库对于数据的重新整理。Mysql分区，这个是mysql对于分区的官方...

php对mysql简单读取的实例

读取mysql数据库例。代码如下复制代码 <?php $link=mysql_connect("localhost","root","之前的管理员密码"); if(!$link) echo "没有连接成功!"; mysql_select_db("infosystem", $link); //选择数据库 $q = "SELECT * FROM info"; //SQL查询语句 mysql_query("SET NAMES GB2312"); $rs = mysql_query($q); //获取数据集 if(!$rs){die("Valid result!");} echo "<table>"; echo "<tr><td>部门名称</td>...

首页 / MYSQL / MYSQL实时触发SQL SERVER 实例

MYSQL实时触发SQL SERVER 实例

内容导读

内容图文

内容总结

内容备注

内容手机端

【MYSQL实时触发SQL SERVER 实例】教程文章相关的互联网学习教程文章

mysql事务处理用法与实例详解【代码】

php+mysql实现数据库随机重排实例

Mysql备份还原数据库之mysqldump实例及参数详细说明【代码】

Spring4 MVC+Hibernate4+MySQL+Maven使用注解集成实例【代码】【图】

9 低级发现Mysql多实例【代码】【图】

highcharts实例教程一：结合php与mysql生成折线图【图】

MySQL Replication主主复制—（实例）【代码】

spring mvc+ibatis+mysql的组合框架入门实例demo源码下载【图】

MySQL索引优化实例说明

(笔记)Mysql实例：建库建表并插入数据2

mysql分区及实例演示【代码】

php对mysql简单读取的实例

30.2. MySQL服务器多实例及测试实验【代码】

MySQL5.5 多实例安装【代码】【图】

mysql多实例安装【图】

SERVER - 相关标签

MYSQL - 相关标签

实例 - 相关标签

MYSQL - 技术教程分类

MYSQL - 最新教程

MYSQL - 最热教程