ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  ERRORS  >>  Database Errors  >>  MySQL Errors
 
 


 

 
 Oracle Errors interview questions  Oracle Errors Interview Questions
 SQLServer Errors interview questions  SQLServer Errors Interview Questions
 MySQL Errors interview questions  MySQL Errors Interview Questions
Question
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'
 Question Submitted By :: Aparna
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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'
Answer
# 1
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 ?    0 Yes 0 No
Laxman
 

 
 
 
Other MySQL Errors Interview Questions
 
  Question Asked @ Answers
 
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
 
For more MySQL Errors Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com