Posted by J.O. Aho on 01/16/07 20:55

Andy wrote:
> "Rik" <luiheidsgoeroe@hotmail.com> wrote in message
> news:581e0$45ad2fed$8259c69c$26539@news1.tudelft.nl...
>> 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

[Back to original message]