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
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

in B i have

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
Messages: 5
Registered: May 2011
Location: Pakistan
Junior Member

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"
Previous Topic: Date Prob In MySQL
Next Topic: MYSQL TO ORACLE MIGRATION---Stored procedures
Goto Forum:

Current Time: Thu Dec 02 23:10:52 CST 2021