1064 error in Mysql Stored Procedure
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
The Table as::
CREATE TABLE USER (
USER_ID INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,
ROLE_TYPE VARCHAR(15) NOT NULL,
BILLING_FIRST_NAME VARCHAR(25) NOT NULL,
BILLING_LAST_NAME VARCHAR(25) NOT NULL,
ADDRESS VARCHAR(230),
CITY VARCHAR(25),
STATE VARCHAR(25),
COUNTRY VARCHAR(15),
ZIP_CODE VARCHAR(15),
COMPANY_NAME VARCHAR(50),
EMAIL_ID VARCHAR(35),
WORK_PHONE VARCHAR(40),
HOME_PHONE VARCHAR(40),
FAX VARCHAR(40),
MOBILE_PHONE VARCHAR(40),
PRIMARY KEY (USER_ID)
);
I get here a MYSQL 1064 error.
Pls suggest how to recover the error.
Thanks,
Bristi