Try to look at page 442 to 446 of the mySQL manual, it may give some help
on your field creation using insert & select.
Regards,
Calvin Chin
[EMAIL PROTECTED]
Ipmuda Berhad - Building materials for tomorrow's world !
-----Original Message-----
From: "Marcus Young" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Sun, 09 Sep 2001 20:44:23 -0500
Subject: INSERT SELECT QUESTION
> Hi,
>
> I'm fairly new to MySQL. I'm trying to insert data into a table where
> one field is derived from a SELECT on another table (a key) and the
> other fields are defined directly (eg field_01="abcd") . The formats I
> have been trying don't appear to be correct. Is the commbined insert
> possible or what is the appropriate technique?
>
> thanks in anticipation,
>
> Marcus
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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