Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Trying to transfer data from Prod region to Test
region.So,exporting data from Prod table(e.g xyz in prod)
into a temporary table(e.g abc) and then inserting into
Test table(e.g xyz in prod),but not able to insert data
from one db2 table to another,the error coming out
is 'foreign key vaue is not valid'



Trying to transfer data from Prod region to Test region.So,exporting data from Prod table(e.g xyz ..

Answer / laxman

insert into abc.tablename(select * from xyz)here xyz is
database1 abc is tempory database but here u select database
is xyz then only this query is excuted if u any doubt mail
me yhis is my mail id laxmanit08@gmail.com
any query u wnt just send a msg ok bye tc



laxman

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More MySQL Errors Interview Questions

what will be the program output if it tries to access 11th item in an array of 10 and it is coded with NOSSRANGE

2 Answers   Cognizant,


What is sqlcode -922 & -923?

2 Answers   Cap Gemini,


Trying to transfer data from Prod region to Test region.So,exporting data from Prod table(e.g xyz in prod) into a temporary table(e.g abc) and then inserting into Test table(e.g xyz in prod),but not able to insert data from one db2 table to another,the error coming out is 'foreign key vaue is not valid'

1 Answers  


mount: mount to NFS server failed: System Error: Connection timed out

0 Answers  


how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

0 Answers  






what is new g/l functionality

0 Answers  


hi friends , could u please suggest the best institute in hyd or bangalore for Oracle apps and pl/sql

1 Answers  


How to select particular number using rownum? Example: i need only the second max number using rownum.

2 Answers   Maveric,


what is the instrument that used in Mechanical Energy??

0 Answers  


hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

0 Answers   Capita India Pvt Ltd,






Categories