FUNCTION AND PROCEDURE IN MYSQL

Still program language “MySQL”.. but with different tutorial. If previously my tutorial is “View in MySQL” then my new tutorial is “Function and Procedue MySQL”. Function in MySQL very significant presence in MySQL. Because function in Mysql used for make up a simple program andc for execute the program.

You know define from Function in MySQL ?? Function in MySQL is set of commands or statement can be saved and can be execute in MySQL database.. We are program can be efficient and effective

And this advantage in using the procedure :

A. Faster

Because the syntax or query that we use will be directly executed or executed on the server. Slightly different if we run the query or the execution of a programming language, for he will go back - behind well as between client to server

B. No Duplication Process

Because MySQL programming languages ​​we know the "primary Key", which is to give the index of a row in order to record the presence of a distinct initials in a column

C. Easy To Maintain

This advantage may be the continuation of benefits "No Duplication Process". because if the same data resulted in us is difficult to distinguish one data degan other data. Because in addition there is a "primary key" to differentiate the key in a table we can also use the "unique" whose function is similar to the "primary key"

D. More Database Security Guaranteed

With the use of a stored procedure would be safer, because the use of storage procedure we do not need to know the information contained in a table when we are required to display a table. As an example, we give a client access to add a record. then he can add (record). but he can only add to it and he can not see the contents of a table

Ok.. just it..

I hope you understand…

See you later..