Java开发网 Java开发网
注册 | 登录 | 帮助 | 搜索 | 排行榜 | 发帖统计  

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate » MySQL  

按打印兼容模式打印这个话题 打印话题    把这个话题寄给朋友 寄给朋友    该主题的所有更新都将Email到你的邮箱 订阅主题
flat modethreaded modego to previous topicgo to next topicgo to back
作者 请教一个“触发器”的写法
JJJIAN





发贴: 2
积分: 0
于 2007-09-07 14:08 user profilesend a private message to usersearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
现在有两个数据库：一个是MySQL，一个是SQL server2000。
在MySQL那边有一个表A，其中有一个属性是mobile, 在sqlserver那边有一个表B，也有一个属性mobile, 请问有什么比较简单的办法可以实现：使当对表A的mobile属性进行更新操作时，同时也更新到表B的mobile属性呢？

JJJIAN edited on 2007-09-11 09:31

作者 Re:请教一个“触发器”的写法 [Re:JJJIAN]
JiafanZhou



版主


发贴: 736
积分: 61
于 2007-11-30 23:20 user profilesend a private message to usersend email to JiafanZhousearch all posts byselect and copy to clipboard. ie only, sorry for netscape users:-)add this post to my favorite list
Open two database connections, and modify this mobile field at the same time. I have never done that type of thing myself, but I think it is feasible.

Regards,
Jiafan

When I was a kid I used to pray every night for a new bike. Then I realized that The Lord doesn't work that way, so I stole one and asked him to forgive me.

flat modethreaded modego to previous topicgo to next topicgo to back
  已读帖子
  新的帖子
  被删除的帖子
Jump to the top of page

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923