Re: Merging two sql databases

Andy wrote:
"Rik" <luiheidsgoeroe@xxxxxxxxxxx> wrote in message news:581e0$45ad2fed$8259c69c$26539@xxxxxxxxxxxxxxxxxxx
Andy wrote:
Please tell me how to merge two sql databases.
Huh? Sql databases? What kind?

Do you know any tutorial about it?
What I want, is to insert data from sql I bought into sql which came
with a website's script. Sql I bought has only one table containing 4
fields: id, name, ingredients, procedure.
Thank you in advance.

Hoepfully you have a user with permission on both databases. If so, choose
to work on the 'extra' database and:

ALTER TABLE table_name RENAME normal_database_name.table_name

It is MySql database.
Do you mean that I supposed to install a database I bought than work on that? I thought that I can merge sqls in a special program.
If so please tell me where I supposed to write the code you posted? (ALTER TABLE table_name RENAME normal_database_name.table_name)
I am new to sql database so I am not sure what to do?

The two databases you have, the one you bought and the one you had, do they have the same table names and column names?

--

//Aho
.

Relevant Pages

  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)
  • Re: dbdebunk Quote of Week comment
    ... But SQL does not have a pointer data type or the ... More and more programmers who have absolutely no database training are ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • RE: [Info-ingres] Re: Pagesize question
    ... d0delim format on the copy INTO (See SQL ref Guide). ... ALTER TABLE is initially quick but there are also other performance issues ... I've written a Ruby adapter for the Ingres ... Ruby on Rails comes with a set of automated tests that ensure a database ...
    (comp.databases.ingres)