Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySql Stored Procedures DB to DB Question

Status
Not open for further replies.
Korizon67

Korizon67

Programmer
Apr 25, 2007
36
US
Hello,

I am trying to come up with a way in Mysql to use a stored procedure to connect to our web database and update table in our internal database. I have php script that does it now once a day

What i would like to accomplish is sweeping our WEB DB every Five minutes to grab new leads. Is this something I can do with MySql itself? maybe a stored proc?

I dont want to have to set windows up to run jobs every five minutes is why i would like to steer away from PHP doing this task. then again maybe mysql can run the php...

thank you in advance for any help/suggestions

Michael
 
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
276
penguinspeaks
penguinspeaks
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
316
BobThornton
BobThornton
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
307
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
274
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
202
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top