473,320 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Copying data between databases

1
Please help me with this.

How can we copy columns from one database to another in mysql database.
Jun 9 '07 #1
2 1379
bartonc
6,596 Expert 4TB
Please help me with this.

How can we copy columns from one database to another in mysql database.
Very easily. But if I tell how to do it here, people might get the impression that this is the MySQL Forum, which it is not. This is the Miscellaneous Questions Forum.
Jun 9 '07 #2
pbmods
5,821 Expert 4TB
Changed thread title to actually describe the problem.

Moving to MySQL forum.
Jun 9 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: 21novembre | last post by:
Hi all, I made a question several days before to describe my strange trouble of mysqldump. But I still can't figour it out. Well, I just want to ask another question whether I could just backup...
1
by: Jani Tamminen | last post by:
I want to copy data from our production database to the development database. I want to move only the data. I do not need the table structure, constrains or anything else. I think I can use the...
1
by: Nitin | last post by:
Hi, How do I prevent users from opening and copying files (related to the project like access files, xml etc). Regards, Nitin
20
by: TC | last post by:
I need an automated procedure to copy data from an Access table to a SQL Server table. Speed is important. What is the recommended technique? I can export the data from Access, copy it via FTP,...
1
by: Peschello | last post by:
I am attempting to copy table data from our live production database to our development database. To do this, I need to specify the name of the database in addition to the table name. I'm running...
6
by: Ryan | last post by:
I have 2 Access '97 databases. I am trying to migrate all the data from one to the other (append to existing records). I do not have Access '97 and opening with Access XP or later causes...
5
by: mark_aok | last post by:
Hi all, I have a situation where I have a split database. At the back end, I need to - create a new table (I will call it newTable) with the exact fields, and relationships as another table...
3
by: tkba | last post by:
I have 2 databases DB#1 abd DB#2. I have TableA in DB#1 which needs to be copied in DB#2 but while doing this I need to change the field#1 which is currently of data type text. Steps taken: 1....
0
by: Icemokka | last post by:
Hi all, We have 2 databases that are not connected to each other directly. Changes to either databases can only be done on one side. Those 2 databases are of the type MSAccess or MSSQL but with...
15
by: Michiel Rapati-Kekkonen | last post by:
my understanding is that you can copy a backend on condition that all recordsets are closed. But it is not what I experience. Is there a way to find out what keeps the backend connected? (maybe I...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.