mysql - using stored procedure to insert values in a table -


i'm new mysql , i'm trying use stored procedure insert values table.can me please

 create procedure insertcust(in lname varchar(30), in fname varchar(30),dob1 date)    begin       insert customer (lname,fname,dob)       values(lname,fname,dob1);//it saying have incorrect syntax ere    end 

if run procedure directly in phpmyadmin should write below

create procedure `insertcust`(in `lname ` varchar(30), in `fname` varchar(30), in `dob1` date)             not deterministic no sql sql security  definer  insert customer (lname,fname,dob)values(lname,fname,dob1) 

i hope you.


Comments

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -