Greetings!
I have two talbes in MySQL, Table1 and Table2.
Table1
id item
1 apple
2 banana
3 orange
Table2
id item
1 shoes
2 suit
3 mango
If I want to add a row/column from Table1 to Table2, is it possible? May be
something like:
insert into Table1 (item) values ((Table2.item) where Table2.id=3);
Looking forward to hearing from you all.
Warm Regards,
DT
---------------------------------------------------------------------
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
