Re: Updating column in same table after insert...
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.