Hi DBAs:
I want to copy TableA in DatabaseA to TableB in DatabaseB
with changes in the attributes of the tables, what options do I have?
I tried these:
a) insert into TableB (id) select (id) from DatabaseA.TableA;
this works
b) insert into TableB (id,data) select (id,data) from DatabaseA.Table
Dear all the mysql DBA:
I'm currently using
mysql Ver 11.9 Distrib 3.23.29a-gamma, for pc-linux-gnu (i686)
May I know is there any workaround for using INTERSECT in this version.
Thanks
SQL and Mysql newbie.
Wee
-
Before p
Dear all the mysql DBA:
I'm currently using
mysql Ver 11.9 Distrib 3.23.29a-gamma, for pc-linux-gnu (i686)
May I know is there any workaround for using INTERSECT in this version.
Thanks
SQL and Mysql newbie.
Wee
-
Before po