|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
07-01-2007, 10:59 PM
| #1 | ||
 |
Hi I have 10 small tables of 3,4 or 5 fields and I want to merge them into one table with 40 or so fields, they all share the same index. eg merge table1 (f1,f2,f3) table2 (field4,field5,field6,field7) into new table table3 (f1,f2,f3,f4,f5,f6,f7) is there any automatic way of doing this (i'm not so bothered if I lose the data) -- David Rayner http://motivation-tips.co.uk/ | ||
     |
|
07-01-2007, 10:59 PM
| #2 | ||
| |
On 6 Jun, 16:20, zzapper <zzap...@gmail.com> wrote: > Hi > I have 10 small tables of 3,4 or 5 fields and I want to merge them > into one table with 40 or so fields, they all share the same index. > > eg merge table1 (f1,f2,f3) table2 (field4,field5,field6,field7) > > into new table > > table3 (f1,f2,f3,f4,f5,f6,f7) > > is there any automatic way of doing this (i'm not so bothered if I > lose the data) > > -- > David Raynerhttp://motivation-tips.co.uk/ INSERT INTO SELECT ... as documented here: http://dev.mysql.com/doc/refman/5.0/...rt-select.html | ||
| |
| Featured Websites | ||||
|
|
| Tags: contents, large, merging, several, small, structure, table, tables |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Merging identical tables | Chuck Anderson | Database | 1 | 07-01-2007 9:29 PM |
| Split large tables | Daniel Onnen | Database | 1 | 07-01-2007 7:27 PM |
| Going for a LARGE Table: Any Tips? | Good Man | Database | 1 | 07-01-2007 6:26 PM |
| Going for a LARGE Table: Any Tips? | Good Man | Database | 0 | 05-31-2007 8:46 PM |
| Best way to structure a table? | J Mox | Database | 13 | 05-31-2007 8:45 PM |
| Featured Websites | ||||
|
Merging the Structure (not just the contents) of several small tables into one large table 
PacMan
Linear Mode
