Interested to Buy Any Domain ? << Click Here >> for more details...
How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 18166 Views
- I also Faced
- E-Mail Answers
Answer Posted / jyoti
SELECT *
INTO table_name [IN externaldatabase]
FROM tablename
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How do I import database through command line?
How do I find users in mysql?
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
Explain % and _ inside like statement?
What are the two types of queries?
Can we store videos in mysql database?
Do while loop in mysql procedure?
What is mysql server?
What is trigger in mysql?
What is difference between mysql_connect and mysql_pconnect?
What does innodb stand for?
What are the functions in mysql?
Why do we use group by and order by function in mysql?
How to escape special characters in sql statements?
How do I set user privileges in mysql?
