•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 397,717 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,567 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 389 | Replies: 7
 |
•
•
Join Date: Jul 2008
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I've taken over a site and i see certain tables being updated without any code on the site doing the update. (It's logical updates so I know its by design and not a hacker)
What I can't see in PHP admin and I also have MySql Query Browser is to find what causes them. I'm assuming its a stored procedure and would like to know how to find them. Is there code to retrieve them.
thanks
What I can't see in PHP admin and I also have MySql Query Browser is to find what causes them. I'm assuming its a stored procedure and would like to know how to find them. Is there code to retrieve them.
thanks
•
•
Join Date: Dec 2004
Location: UAE
Posts: 406
Reputation:
Rep Power: 5
Solved Threads: 9
Posting Pro in Training
•
•
Join Date: Jul 2008
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thanks I'll be looking at this tomorrow. I appreciate the help
•
•
Join Date: Jul 2008
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
So I've realized lookin at the links I am looking for a trigger not a stored procedure. I've used show triggers to get a list of the triggers but have not figured out how to get the synax of the trigger themselved.
•
•
Join Date: Jul 2008
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Tried it and received an error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER updateNextPaymentDate' at line 1
My sql was
SHOW CREATE TRIGGER updateNextPaymentDate;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER updateNextPaymentDate' at line 1
My sql was
SHOW CREATE TRIGGER updateNextPaymentDate;
Last edited by michaelh613 : Jul 21st, 2008 at 7:51 am.
•
•
Join Date: Jun 2008
Posts: 38
Reputation:
Rep Power: 1
Solved Threads: 5
Light Poster
ACTION_STATEMENT column will have the sql in trigger
•
•
Join Date: Jun 2008
Posts: 38
Reputation:
Rep Power: 1
Solved Threads: 5
Light Poster
Try this :
This should work for sure
Show Create trigger trigger_name should also work,but for some reason its not
you can go with the Above query
This should work for sure
select TRIGGER_SCHEMA,TRIGGER_NAME,EVENT_MANIPULATION,EVENT_OBJECT_TABLE,ACTION_STATEMENT from information_schema.TRIGGERS;
Show Create trigger trigger_name should also work,but for some reason its not
you can go with the Above query
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Similar Threads
- Simple ASP.Net Login Page using C# (C#)
- Updated : Simple ASP.Net Login Page (ASP.NET)
- Stored Procedure Help Needed. (VB.NET)
- How to change into stored Procedure (ASP.NET)
- Calling and executing stored Procedure (C)
- Getting "DB_E_ERRORSINCOMMAND" even when execute is successful (C)
- Asp.net 2.0 (ASP.NET)
- procedure and object-oriented ! (C)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
Other Threads in the MySQL Forum
- Previous Thread: Query help
- Next Thread: Bots IP Database
