Apply for Zend Framework Certification Training

Mysql





DELIMITER //
CREATE PROCEDURE insert_user_data (IN first_name VARCHAR(50),IN last_name VARCHAR(50))
BEGIN
    INSERT INTO tbl_user (first_name,last_name) VALUES (first_name,last_name);
END //
DELIMITER ;
CALL insert_user_data('rajesh133','kumar188');                                    

HI viewers
Here I am going to discuss about the code that i have used for
to insert data in mysql using stored procedure

Here in insert_user_data (IN first_name VARCHAR(50),IN last_name VARCHAR(50))
IN inside parenthesis is used to define input and its Data type

< swap two variable value in php Distinct in codeigniter >



Ask a question



  • Question:
    {{questionlistdata.blog_question_description}}
    • Answer:
      {{answer.blog_answer_description  }}
    Replay to Question


Back to Top