Hi Carlos,
I believe that would have to be 2 separated steps.
1) creating the value in the primary key and
2) creating the foreign key value
However you can use UNION to write both statements in one go.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 26日 土曜日 05:20、Write a Friend さんは書きました:
> I am a newbie to db.
>
> I have a few tables, one that I define the primary key.
>
> CREATE TABLE member (
> memid INT(6) UNSIGNED ZEROFILL DEFAULT '002000' NOT NULL
> AUTO_INCREMENT, last VARCHAR(20) DEFAULT '' NOT
> NULL, first VARCHAR(20) DEFAULT '' NOT NULL, mi
> CHAR(1) DEFAULT '' NOT NULL, PRIMARY KEY(memid),
> INDEX name (last,first,mi)) TYPE=INNODB;
>
>
> CREATE TABLE memadv (
> memid INT(6) UNSIGNED ZEROFILL DEFAULT '002000' NOT NULL,
> advtype ENUM('A','T','C') DEFAULT 'C' NOT NULL,
> FOREIGN KEY (memid) REFERENCES member(memid)
> ON UPDATE CASCADE ON DELETE RESTRICT,
> INDEX id (memid,advtype)) TYPE=INNODB;
>
> What I want is for the primary key to be auto generated and propagated
> to the other table's memid automatically, when data is entered for
> the member table? Does that make sense? Am I doint this correctly?
>
> Thanks for the help,
> Carlos
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
