i have 2 tables artist and employee as
artist(artistId,name,contact,address,employeeId) and
employee(employeeId,name,contact,email)
here artistId and employeeId are primary key and set to auto increment.
I want to insert data into artist table but artist can not insert employee Id.So how it will get assigned to artist? what should I write?
i have written following query in stored procedure without employee id:
insert into artist(name,contact,address)values(name,contact,address).
Please help.