Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

How we can copy one table data into another table whose name
same as table but in differ database

Question Posted / jyoti

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


Please Help Members By Posting Answers For Below Questions

How to check if a record exists in a mysql database php?

880

What is mysql community server?

927

How many ways to get the current time?

967

What does tinyint mean?

903

how to connect a php script with the mysql database?

1037

can you tell what are the different set operations available in mysql? : Mysql dba

884

Write a query to stop mysql in unix

1044

How to show certain selected rows with the value "pcds".

926

How do I copy a table in mysql workbench?

876

What are the drivers in MySQL?

1453

What is mysql ndb?

884

What are mysql queries?

915

How is mysql database stored?

1057

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

2128

How does mysql encrypt passwords?

889