haibec Posted September 4, 2006 Share Posted September 4, 2006 Hi guys!I have two table User includes field ID,username and Infor includes field ID,Gold . I want make a trigger : add 1000 gold for users have ID>=10 . PLease help me.! Link to comment Share on other sites More sharing options...
tutsamewasa Posted September 4, 2006 Share Posted September 4, 2006 Hi, Why do you need Trigger for simple update, just write an update query that will do?set Gold = Gold + 1000??If there is some thing that I got incorrect please let me know.Hope this helps.Good LuckHemendra Singh ShaktawatMindfire Solutionswww.mindfiresolutions.com Link to comment Share on other sites More sharing options...
haibec Posted September 4, 2006 Author Share Posted September 4, 2006 Hi, Why do you need Trigger for simple update, just write an update query that will do?set Gold = Gold + 1000??If there is some thing that I got incorrect please let me know.Hope this helps.Good LuckHemendra Singh ShaktawatMindfire Solutionswww.mindfiresolutions.comOkie! please help me Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now