Hello Andreas,
You could try with this:
> insert into table1 (authorid, lastname, firstname)
> values (nextval('s_authors'), 'Meyers', 'Scott');
INSERT INTO table1(authorid, lastname, firstname)
VALUES (null, 'Meyers', 'Scott');
> insert into table2 (authorid, title, subtitle)
> values (currval
Hi Andreas!
Andreas Bauer wrote:
In my postgres database, the value of the
insert into command of the table 2 is
currval(sequence).There are severally such insert into
commands back-to-back:
insert into table1 (authorid, lastname, firstname)
values (nextval('s_authors'), 'Meyers', 'Scott');
Hello NG,
I have to migrate a postgres database to a mysql data-
base. There are some problems applying this.
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 when I have to f
