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

< Select Query with distinct or group by Import databases from live to localhost using commond prompt >



Ask a question



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

(+91)-9910699802
Become A Member     Become A Teacher
Back to Top