Stored procedures?

[comadreja]

Hi, I would like to add a function to my MySQL which can be called as a command, something like this:
BEGIN;
INSERT INTO table1 VALUES (...);
INSERT INTO table2 VALUES (...);
DELETE FROM table1, table2 WHERE ...;
GET_UPDATE();
COMMIT;

where GET_UPDATE is my function. Anybody can help me and teach me how to do it?

Thank you very much!

 

[sleipnir214]

You can't. Stored procedures are a planned feature of MySQL 5.x, which is not due out for some time. (

http://www.mysql.com/doc/en/ANSI_diff_Triggers.html).

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!