Re: Insert if exists
Posted by: Macamba .
Date: January 04, 2016 03:29AM

The (!), oh sorry, that's me being too smart. That is the place where MySQL states where the error should occur.

Quote

With so many nullable columns, wouldn't it be simpler & more efficient to simply declare them default null?

Would the record still be unique if I run the script? In an earlier script I had values for these fields. But I then taught of the 'Fill in your own address information' entry in the street field. This is shown in the application almost at the top of the window.

Options: ReplyQuote


Subject
Written By
Posted
January 03, 2016 07:50AM
January 03, 2016 12:46PM
Re: Insert if exists
January 04, 2016 03:29AM
January 04, 2016 03:52AM
January 04, 2016 04:39AM
January 18, 2016 05:44PM


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.