Posted by Andy on 01/16/07 20:52

"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
> --
> Rik Wasmus
>
>
>
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?

Andy

[Back to original message]