Home » Open Source » MySQL » Alter table from different databases (Mysql 5,Windows)
Alter table from different databases [message #492565] Tue, 01 February 2011 03:16 Go to next message
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


Re: Alter table from different databases [message #505858 is a reply to message #492565] Thu, 05 May 2011 05:37 Go to previous message
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.
Previous Topic: Date Prob In MySQL
Next Topic: MYSQL TO ORACLE MIGRATION---Stored procedures
Goto Forum:
  


Current Time: Fri Nov 28 01:02:55 CST 2014

Total time taken to generate the page: 0.05147 seconds