SearchWiki
NoSQL.RecentChanges
Edit Page
Page Revisions
Groups available

CSA
Calendar
Main
NoSQL
People
PmWiki
PmWikiIt
PtvDev
RssFeeds
ScriptaVox
ScriptaWeb
ScriptaWiki

Quick links

TextFormattingRules
Edit Menu

Campaigns

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:

      union TABA TABB

<< ModifyingTables | NoSQL.DocumentationIndex | ImportingData >>
Edit Page - Page Revisions - WikiHelp - SearchWiki - RecentChanges - Printable version
Page last modified on September 01, 2003, at 23:42 (CEST)