Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
  • Stored routies in Mysql

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 283
    Comment on it

    Welcome to Findnerd. We are going to explain the storage procedure and functions. It is also known as stored routines. Stored routines is available from Mysql5.7. There is table named proc which is required to work with stored routines. It will be created itself when you install the version Mysql5.7 and above.

    It is not required to write the same queries again and again. Queries will be stored on database server. Different applications can run the same stored procedures as per the requirement. It will increase the load of the databases server because most of work will be done on database server.

    Stored routines also provides different libraries on database server. You can simply create and drop the procedures using queries.

    CREATE PROCEDURE `nerd` ()
    COMMENT 'A procedure'
        SELECT 'Hello World !';

    You need to mention the name of the procedure which is case-insensitive and different characteristics of procedure. LANGUAGE for portablilty purpose, Deterministic for replication, SQL SECURITY for checking privileges of the user,default value is DEFINER, creator of the procedure. COMMENT for documentation purpose. You can call the stored procedure like this

    CALL stored_procedure_name (param1, param2, ....) 

 0 Comment(s)

Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: