I was wondering if someone could help me with the following problem. I
need to copy some content from a table in one database and import it
into a table in another mySQL database. I was thinking of writing a
script to format the output of
select * from directory where parent = num into outfile ~/dirtable.txt
with the appropriate insert into table values( ...,...,....); format.
Is there an easier way of accomplishing this through mySQL?
Thanks for your help,
701 New Media