The MySQL database server software, which powers many websites and business applications, uses a dialect of the industry-standard Structured Query Language for database maintenance and transaction ...
Listing 5. This procedure demonstrates a technique for combining an Insert statement and an Update statement into a single stored procedure. CREATE PROCEDURE STDA.CustomersUpdate @CustomerID NCHAR(5), ...
I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.