MySQL Forums
Forum List  »  Triggers

Re: Updating column in same table after insert...
Posted by: Jim Reamer
Date: September 05, 2017 02:34PM

Peter Brawley Wrote:
-------------------------------------------------------
> 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



That's fine and good, but can I get help to solve my direct need?

I'm using my own data table to interact with a WordPress data table within the same database. I can't efficiently restructure their data tables (nor would I know how), and to automate a great deal for the site in question, the easiest way to do that is to match the column I'm trying to self-populate.


I can just type it as I go, but some of it will be by others and off various types of devices. I'd like to eliminate as much room for error as possible. That's more efficient use of my time and my writers' time.

Options: ReplyQuote


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


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.