How to Use Default Column Values in Stored Procedures
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?
Subject
Views
Written By
Posted
How to Use Default Column Values in Stored Procedures
1055
August 29, 2018 08:52PM
499
August 29, 2018 09:29PM
501
August 30, 2018 02:30AM
Sorry, you can't reply to this topic. It has been closed.
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.