Re: Help - Export/Import a Row

Unfortunately, there is no way to selectively export rows from a table. My suggestion would be to

CREATE TABLE table_temp
AS SELECT * FROM table_name
WHERE ... Then you can export this table and import into your final database. Now you can INSERT into your destination table as SELECT * from table_temp;

Hope this helps,
CM

In article <6i51qo$ft5_at_nntp02.primenet.com>#1/1,   vole_at_primenet.com (Joe Gervais) wrote:
>
> Howdy Folks,
>
> Sorry if this is in the FAQ, but I couldn't find it.
> Can anyone help me figure out how to export a database
> row from a single table to file, and then import the
> row back into an equivalent table in another database
> (on a separate network).
>
> I'm looking into spool and sqlload, but that seems like
> overkill. Is there an easier way to do this?
>
> Thanks in advance!
>
> Cheers,
>
> -Joe, vole_at_primenet.com
>
> "And that, my Liege, is how we know the Earth
> to be banana-shaped." -- Monty Python and the Holy Grail
> --
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 12:24:45 CDT