insert data into DB by column
*** to get the column names ***
RUN THIS W/RIGHT table NAME
SELECT *
FROM dmnavigation;
*** choose export flat file, click the "Generate Columns" or
"Options" save to clipboard
INSERT INTO dmnavigation
(column names)
SELECT column names
FROM [EMAIL PROTECTED];
Exp:
INSERT INTO dmnavigation
(CREATEDBY,DATETIMECREATED,DATETIMELASTUPDATED,EXTERNALLINK,LABEL,LASTUP
DATEDBY,LNAVIDALIAS,LOCKED,LOCKEDBY,OBJECTID,OPTIONS,STATUS,TITLE,ISVISI
BLE)
SELECT
CREATEDBY,DATETIMECREATED,DATETIMELASTUPDATED,EXTERNALLINK,LABEL,LASTUPD
ATEDBY,LNAVIDALIAS,LOCKED,LOCKEDBY,OBJECTID,OPTIONS,STATUS,TITLE,ISVISIB
LE
FROM [EMAIL PROTECTED];
> Not sure if this will make any since but here it is..
we use Toad to access the DB's..
Ian Redding
NTP Website System Administrator (http://ntp.niehs.nih.gov)
Contractor - INDUS Corp (www.induscorp.com)
E-mail: [EMAIL PROTECTED]
919-541-0642
-----Original Message-----
From: RobG [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 11, 2007 2:04 PM
To: [email protected]
Subject: [farcry-dev] Re: Setting up a duplicate (development) FC
instance
Redding, Ian (NIH/NIEHS) [C] wrote:
> I did the same thing but using O-10g
> Used a sql statement to move the data from one table to another
> I'm looking for my statement but it is written w/my DB names & Oracle
> Have not used MySql but wld like to try it for knowledge
> Let me know if u want the sql & u can try it??
Yes, please... would like to see it. I'm sure I can convert it to
MSSQL. Or at least it'll get me started.
Thanks!
Rob
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
