Hi!
I need help with my stored procedure mysql statement.
I have two tables namely department with fields ( department id , department name) and employee with fields ( employee id, department id, employee name)
I have to update my tables using stored procedure and I dont know whats wrong with my sql statement please help...
delimiter //
create procedure nsrt
( in dpid int(4),
in dpname varchar (10),
in eid int,
in ename varchar(30) )
begin
insert into department(deptid,deptname),
employee(Empid,empname)
values (department.deptid=dpid,
department.deptname='dpname',
employee.`Empid`=eid,
employee.`empname`='ename')
where (department.deptid=employee.deptid);
end //