FAQ & Downloads
Die Datenbank enthält von unserem Team erstellte Dokumentationen. Bitte wählen Sie eine Kategorie aus oder suchen Sie nach Antworten.
Articles
How can I add procedures and triggers to my MySQL database?
As more and more clients want to use advanced SQL features from their Java applications,at JVM Host we are running MySQL version 5.1.x where user can run CREATE PROCEDURE and CREATE TRIGGER statements.
Just make sure that you check ROUTINE and TRIGGER related privileges or ALL privileges when assigning database user to a database.
Read more on the statements in MySQL documentation:
CREATE PROCEDURE Syntax
CREATE TRIGGER Syntax
You can create procedures using command line 'mysql' client or any other client.
From GUI clients we recommend MySQL WorkBench.
- © 2016-2024 JVMHost.com All rights are reserved.