Insert Default on error
I am getting this error below.. I have *tried* to search for a solution, but I am unable to find one. I have a PHP script that is returning this error:
Incorrect integer value: 'f' for column 'weight' at row 1insert ps_product
I have a default value configured for the column.. How can I get MySQL to input the default value on an error?
In other words.. If a value that is being inserted into the column does not meet the specifications of the column, how do you tell MYSQL to insert the default value configured for the column instead?
Subject
Views
Written By
Posted
Insert Default on error
1951
June 03, 2014 08:32PM
839
June 04, 2014 07:16PM
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.