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
Post a Comment