Solved

Data in row trigger batch

Posted on 2014-01-11
2
314 Views
Last Modified: 2014-03-03
Hi all,

I am looking to see if this is possible.

When a row is populated with data (typically the first row), I want to then automatically trigger a batch file to start.

Is this possible?

I'm using phpmysql so don't think that it's possible, however I can use MySQL from Microsoft as I have a licence. Although, not fully sure what version I should be using.

Thanks in advance
0
Comment
Question by:oconnork00
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
duncanb7 earned 500 total points
ID: 39774646
Could you write php code to access your database ? and then use
exec() function  in your php code  to trigger your batch file running on window
when the rows data is updated or accessed.
There is apache server for  window  version such as XAMPP  that you can run
php programming. If not, I think it is hard to do that on just mysql or phpmyadmin
and only mysql running on batch mode  with system command
to trigger shell command , for example, mysql>system ls that will list linux directory

Hope understand your question completely, if not , please pt it out

Duncan
0
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 39778654
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

626 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question