CREATE PROCEDURE rbuilder(
IN uid INT,IN name VARCHAR(30),
IN sex VARCHAR(1),
IN dob DATE,
IN address VARCHAR(200),
IN country VARCHAR(2),
IN state VARCHAR(20),
IN city VARCHAR(20),
IN zip VARCHAR(10),
IN mobile VARCHAR(10),
IN email VARCHAR(30),
IN aoe VARCHAR(250),
IN planguages VARCHAR(250)
IN comments VARCHAR(250)
) BEGIN
START TRANSACTION
INSERT INTO rbuilder_info (uid,name,sex,dob,address,country,state,city,zipcode,mobile,email)VALUES('',uid,name,sex,dob,address,country,state,city,zip,mobile,email);
INSERT INTO rabuilder_skills VALUES('',aoe,planguages,coments);
COMMIT
END
Please do help me to make it work showing some syntax error;
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO rbuilder_info (uid,name,sex,dob,address,country,state,city,zipcode,m'