Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001
    Posts
    46

    Unanswered: Merging multiple tables

    Evening chaps

    I've got a couple of hundred tables, unlinked, storing data. Can I easily condense them into one table, using a JOIN or UNION statement?

    Any-thoughts?

    Thanks

    Mike

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Do they have an identical structure? If so, how about setting up one MERGE table?

    http://dev.mysql.com/doc/mysql/en/me...ge-engine.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •