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?
Submitted by: Administratorinsert 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
Submitted by: Administrator
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
Submitted by: Administrator
Read Online MySQL Errors Job Interview Questions And Answers
Top MySQL Errors Questions
☺ | Explain What is sqlcode -922 & -923? |
☺ | Explain How to select particular number using rownum? |
☺ | Tell me what will be the program output if it tries to access 11th item in an array of 10 and it is coded with NOSSRANGE? |
Top Exception Handling Categories
☺ | ERRORS Interview Questions. |
☺ | Scripts Errors Interview Questions. |
☺ | Oracle Errors Interview Questions. |
☺ | C C++ Errors Interview Questions. |
☺ | DotNet Errors Interview Questions. |