Hello NG,
how can I implement a reference in phpmyadmin between two fields from
two different tables, so that the two fields of the two different tables
have the same values? And if I have to fill this two tables by building and
executing
the insert into command, which default value of the referenced fields do I
have
to take using the insert into command? The primary key ID field of the first
table do not have a value by building the insert into command.
But the other referenced field of the table two? Which value using insert
into?
The two referenced fields are an auto_increment, primary key ID
field of the table 1 and another field, Typ: index, of the table 2.
In postgres the value filling the table 2 is currval(sequence), how
to in mysql?:
insert into table 2 (authorid, title, subtitle)
values (currval('s_authors'), 'Effektiv C++ Programmieren',
'50 Wege zur Verbesserung Ihrer Programme und Entwuerfe');
Best regards
Andreas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
