Community Platform

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
Number of Views:356
Posting Details
Publication date: 0000-00-00
Tags
Tags:
Added 2005-12-29 by kgollada, Modified 2011-09-27 by kuttkeUI

Comments

No comments.