how to write procedure to insert data in to the table in phpmyadmin

Question

I have created table as below   student   ---- ------ ----------- --------   uid   name   user name   branch    ---- ------ ----------- --------                                      ---- ------ ----------- --------    I want to insert data in to the table using procedure   the procedure which i wrote is      create procedure add in name varchar 50  in user name   varchar 50  in branch varchar 50     begin   insert into student    name user name branch  values  in name  in user name in branch     end

User · Accepted Answer

Try this-  CREATE PROCEDURE simpleproc  IN name varchar 50  IN user name varchar 50  IN branch varchar 50   BEGIN     insert into student  name user name branch  values  name  user name branch   END

User · Answer

Switch delimiter to     so phpMyAdmin will not execute it line by line  DELIMITER    CREATE PROCEDURE usp rateChapter12   IN numRating Chapter INT 11  UNSIGNED     IN txtRating Chapter VARCHAR 250     IN chapterName VARCHAR 250     IN addedBy VARCHAR 250      BEGIN DECLARE numRating Chapter INT   DECLARE txtRating Chapter VARCHAR 250    DECLARE chapterName1 VARCHAR 250    DECLARE addedBy1 VARCHAR 250    DECLARE chapterId INT   DECLARE studentId INT   SET chapterName1   chapterName  SET addedBy1   addedBy   SET chapterId    SELECT chapterId                     FROM chapters                     WHERE chaptername   chapterName1    SET studentId    SELECT Id                     FROM students                     WHERE email   addedBy1    SELECT chapterId  SELECT studentId   INSERT INTO ratechapter  rateBy  rateText  rateLevel  chapterRated  VALUES  studentId  txtRating Chapter  numRating Chapter chapterId    END       DELIMITER

User · Answer

This method work for me   DELIMITER    DROP PROCEDURE IF EXISTS db test    CREATE PROCEDURE db test IN id INT 12  IN NAME VARCHAR 255    BEGIN  INSERT INTO USER VALUES id NAME    END   DELIMITER

[mysql] how to write procedure to insert data in to the table in phpmyadmin?

Examples related to mysql

Examples related to database

Examples related to stored-procedures

Examples related to phpmyadmin