Copy one table to another
| User, date | Message |
|---|---|
|
Written by Soccot
5 years ago Category: General 2 posts since Mon, 23 Jun 08 |
So... I have datas in one table. Letīs call it xxx. And i want to copy some Data from xxx to yyy another table. For example: There ist user_Id in xxx and not in yyy. How to copy the user_id datas to yyy? Sorry or my crappy English Best greets Soccot |
|
Written by Dr. Dave
5 years ago 95 posts since Sun, 27 Jan 08 |
This is a feature that I have wanted to see implemented for a long, long time, but just doesn't exist. The best advice I can give is to Export table xxx, open the saved .sql file with TextPad (or Notepad), change all the xxx references to yyy, then run the query with Heidi. It's super quick and so far, the best method I know. |
|
Written by Soccot
5 years ago 2 posts since Mon, 23 Jun 08 |
thx man I got it |
|
Please login to leave a reply, or register at first. |