MySQL Forums
Forum List  »  Stored Procedures

How to Use Default Column Values in Stored Procedures
Posted by: Arthur Chan
Date: August 29, 2018 08:52PM

I have tables with default values for many columns.

I am using stored procedures to INSERT values into these tables e.g. CUSTOMER where the default value for Country is 'USA'.

How to I code the sproc to get it to insert Country using the column default value?

I do not want to have to specify all the IN values when defaults are available b/c I am using a cloud database via wifi and https, and the URL gets very long.

Does mySQL even support this feature?

Options: ReplyQuote


Subject
Views
Written By
Posted
How to Use Default Column Values in Stored Procedures
241
August 29, 2018 08:52PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.