MySQL Lab Assignement #6

Due: 4/12/2012

Turn in source code for Stored procedure.

Write a stored procedure for the customer table.  The stored procedure should accept as parameters all the columns for the customer table. 

If the customer number is 0 or NULL then insert all the data into the customer table and return the new customer number via the customer number parameter.  Otherwise update the data in the customer table. 

Extra Credit:

If customer # > 0, but that number doesn't exists in the customer table, then return -1 via the output parameter

If customer # < 0, then return -1 via the output parameter