-
Sorry, there was an error processing record:
-
Please contact us at
[email protected]
. We are sorry for the inconvenience.
Back
Search
Knowledgebase
Documents, videos, websites and more.
Appending tables in MySQL
Brief description or abstract:
When it is necessary to append (i.e. stack on top of each other) tables in MySQL, use the one of the following bits of code: 1. For cases where table structure is different (i.e. the different files have different variables and/or different definitions for certain variables): INSERT INTO x ([comma-separated field list]) SELECT [field list] FROM y; 2. If the structures are identical, you can skip the field lists: INSERT INTO x SELECT * FROM y;
Posting type(s):
Links & Files
URL:
Regions & Topics
Geographic regions:
United States
Topic(s):
Subtopic(s):
Number of "Likes":
0
-
Sorry, there was an error processing record:
-
Please contact us at
[email protected]
. We are sorry for the inconvenience.
Number of Views:
Posting Details
Publication date:
0000-00-00
Tags
Tags:
Added
2005-12-29
by kgollada, Modified
2011-09-27
by kuttkeUI
Comments
No comments.
Add your comment: