You will need to employ a scripting language then. This is the type of thing that spawned PL/SQL in Oracle and the like.
You can use PHP to do it.
The reason SQL doesn't allow that, is due to the rules of data normalization. Replicating the same data in multiple tables is inefficient, and hence SQL as a language doesn't really allow you to get straight to it, you need to go around.
There are reasons to do what you are talking about, especially in a data warehousing environment, but normally in a production database, replication should be kept to a minimum.
__________________
I rarely give code examples.
No, I have never used IIS or Windows of any kind as a web server. Get a real OS!
Please don't PM me, I won't respond.
|