OraFAQ Forum: MySQL » Alter table from different databases

Home » Open Source » MySQL » Alter table from different databases (Mysql 5,Windows)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Alter table from different databases [message #492565]

Tue, 01 February 2011 03:16

sunilpaladugu
Messages: 5
Registered: August 2010
Location: Pune

Junior Member

Hi all
I have two databases let A and B

The A and B databases have same table like

in A i Have
id,Name

in B i have
id,Name

My query is

If i do a alter(adding a column) on A's table,It's automatically add column to the B's table also

Thanks in advance

Report message to a moderator

Re: Alter table from different databases [message #505858 is a reply to message #492565]

Thu, 05 May 2011 05:37

sairakhushi
Messages: 5
Registered: May 2011
Location: Pakistan

Junior Member

Hello!
In my opinion you should use database name separated by a dot(.) with the table name and then alter anything you need to. Like a.id or alter table a.id set "column_name" = "value"
Thanks
Saira.

Report message to a moderator

Previous Topic:	Date Prob In MySQL
Next Topic:	MYSQL TO ORACLE MIGRATION---Stored procedures

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 04:45:28 CDT 2013

Total time taken to generate the page: 0.29459 seconds