Error in mysql stored procedure,pls help
Hi all,
Pls Check the Mysql code.
CREATE PROCEDURE data_insert (First_Name VARCHAR(30) IN, Last_Name VARCHAR(30) IN,Addr VARCHAR(230) IN,
State1 VARCHAR(25) IN,ZIP VARCHAR(20) IN,Company VARCHAR(50) IN,Email VARCHAR(35) IN,WPhone VARCHAR(40) IN,HPhone
VARCHAR(40) IN,Fax VARCHAR(30) IN,MPhone VARCHAR(40) IN)
BEGIN
INSERT into user (billing_first_name,billing_last_name,address,state,zip_code,company_name,email_id,
work_phone,home_phone,fax,mobile_phone)values(First_Name,Last_Name,Addr,State1, ZIP,Company,Email,
WPhone,HPhone,Fax,MPhone);
END;
I get here a MYSQL 1064 error.
Pls suggest how to recover the error.
Thanks,
Bristi