Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by oconnork00
at 2024-01-11 06:55:56
Point:500 Replies:2 POST_ID:828880USER_ID:10
Topic:
MySQL Server;;
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
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
Expert: TomasHelgi replied at 2024-01-14 01:23:23
Hi!
You can use UDF for this see these links for more info
http://patternbuffer.wordpress.com/2012/09/14/triggering-shell-script-from-mysql/
<link removed - Cathal>
http://crazytechthoughts.blogspot.com/2011/12/call-external-program-from-mysql.html
Some useful stuff
http://www.mysqludf.org/
UDF in the MySQL manual
http://dev.mysql.com/doc/refman/5.5/en/adding-udf.html
http://dev.mysql.com/doc/refman/5.5/en/create-function-udf.html
Hope this helps.
Regards,
Tomas Helgi
You can use UDF for this see these links for more info
http://patternbuffer.wordpress.com/2012/09/14/triggering-shell-script-from-mysql/
<link removed - Cathal>
http://crazytechthoughts.blogspot.com/2011/12/call-external-program-from-mysql.html
Some useful stuff
http://www.mysqludf.org/
UDF in the MySQL manual
http://dev.mysql.com/doc/refman/5.5/en/adding-udf.html
http://dev.mysql.com/doc/refman/5.5/en/create-function-udf.html
Hope this helps.
Regards,
Tomas Helgi
Accepted Solution
Expert: duncanb7 replied at 2024-01-12 04:16:13
500 points EXCELLENT
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
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
