Stored procedure

[CatPlus]

Hello all:

I am trying to get out of a proprietory LAN based database
and use MySQL as my back end database and PHP and my
front end interface

I am told that MySQL does not support Stored Procedures or
triggers

Here is what I want to do and I will appreciate your comment
whether there are ways how my requirements are fulfilled
using MySQL

[a] I have a user who takes orders all day.
The order confirmation is e-mailed during a night batch
process
[c] The procedure must update the database with several
values, like a block on inventory quantities, etc.

Thanks
Mickey Shekdar

 

[sleipnir214]

You don't need stored procedures or triggers for what you're planning to do. Want the best answers? Ask the best questions:

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

TANSTAAFL!

 

[CatPlus]

Thank you sleipnir214!

If not stored procedure, what is the function called?

Thank you

 

[CatPlus]

Here is a description of Stored Procedure I searched at
MySQL.com

A stored procedure is a set of SQL commands that can be compiled and stored in the server. Once this has been done, clients don't need to keep re-issuing the entire query but can refer to the stored procedure. This provides better performance because the query has to be parsed only once, and less information needs to be sent between the server and the client. You can also raise the conceptual level by having libraries of functions in the server

How do you explain my original question

Thanks

 

[sleipnir214]

<sarcasm>
I don't have to explain your original question. It's your question, you explain it.
</sarcasm>

Okay, you found at the MySQL website an explanation of what a stored procedure is. That doesn't change the fact that MySQL does not support them, and will not until version 5, which is due out at the end of this year.

That quote also does not change the fact that you do not need stored procedures or triggers to do what you want to do.

And if you thought I needed an explanation of what a stored procedure was, it would have been better to have expected me to ask, &quot;What's a stored procedure?&quot;

But I guess I never did answer your question explicitly. Yes, MySQL can support the activity you describe. And as I said before, there is nothing yet you have described which would predicate a need for stored procedures or triggers.

MySQL can easily support a large number of simultaneous users entering orders into the database. I do it with web-frontend e-commerce systems all day long.

Emailing order confirmation can easily be handled by whatever external scripting language you plan to use.

The third part of your question cannot be answered, as it describes a database use activity too generally. Want the best answers? Ask the best questions:

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

TANSTAAFL!