INSERT INTO SELECT ??

2001-10-02 Thread chong wee siong 

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.TableA;
but this does not work, why? and how do I do this?

The mysqlhotcopy copy the whole database or it can copy a single table?

Thanks a lot.

Wee


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

workaround for INTERSECT?

2001-09-30 Thread chong wee siong 

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 posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: demande d'information

2001-09-30 Thread chong wee siong 

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 posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php