On Tue, 23 Jan 2001, Alexei Sh. wrote:
|Ok I need help
|So i have table with primary key ID,
|it's fills with something like 1,2,4,5
|So and i have another table in which i would like to put data from first
|table from row ID
|how to do this
||--------| |--------|
|| test1 | | test2 |
||--------| |--------|
|| ID |--------> | Cus_ID |
|| name | | aaa |
|| bla | | aaa1 |
||--------| |--------|
|in this table
|ID - primary key
|
|datas from ID in table test1 must be inserted into test2 in row Cus_ID
|How to do this ?!
Depends on what your are using as a program (perl, cgi, php, etc). With a
program you can store the id in a var and insert insert it.
I am not sure whether there is a possiblity from the mysql prompt.
Adrian
--
===================
Adrian D'Costa
[EMAIL PROTECTED]
www.pcsadvt.com
===================
---------------------------------------------------------------------
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