NoSQL: a non-SQL RDBMS
Recent Pages

Text Formatting Rules
Site SandBox
Change Management
Wiki Editor's How-To
Site Terms of Use
Site Copyright
Perl and NoSQL
Notes for Contributors
Table header
Philosophy of NoSQL

Links

NoSQL Home
Table of Contents
Wiki Editor's How-To
Text Formatting Rules
Wiki SandBox

www.strozzi.it on Twitter


GeoURL

Advertising

Please Support NoSQL !


Session

User ID
Password
Sign-in or register with OpenID


Campaigns

stopsoftwarepatents.eu petition banner

Concatenating tables

The need to concatenate tables comes up every so often, and, although it is simple to do the method may not be obvious. The UNIX 'cat' command cannot be used as it would result in duplicating the header and thus cause an invalid output table. And, of course, only tables with the same header, i.e. tables that are said to be ``union-compatible,'' should be concatenated, otherwise an invalid table would result. If we have two tables, TABA and TABB, then to concatenate TABB onto the end of TABA we use the command:

       tablecat TABA TABB

Trackbacks (1) | New trackback | Comments (0) | Print

This Web Site is Copyright © 2007,2008,2009,2010 Carlo Strozzi, Some Rights Reserved
site map | recent changes | terms of use