MySQL Forums
Forum List  »  Triggers

Re: Updating column in same table after insert...
Posted by: Peter Brawley
Date: September 05, 2017 02:15PM

> I'd like a column (name) to reflect entry from two other columns (nameFirst and nameLast). I'm trying to do so via this trigger:

A design error. A basic job of a well designed table is to minimise redundancy, not increase it. For display purposes, consider a View that combines first & last names as desired.

Read about the basic principles of relational databases, eg at http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.pdf

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Updating column in same table after insert...
434
September 05, 2017 02:15PM


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.