Value of a referenced field

2006-06-29 Thread Andreas Bauer
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

How to create references and insert into values in phpmyadmin?

2006-06-28 Thread Andreas Bauer
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

Merging two fields; references to fields

2006-06-26 Thread Andreas Bauer
Hello NG, I have two tables, three and four fields inside, in my mysql database, created with phpmyadmin: t_authors 1 authorid (primary key, auto_increment) 2 lastname 3 firstname t_books 1 bookid (primary key, auto_increment) 2 authorid (Typ:index, reference to t_authors.authorid, done with

create view and insert into problems

2006-06-25 Thread Andreas Bauer
Hello NG, I have two tables in my mysql database created with phpmyadmin: t_authors: 1 authorid (primary key, auto_increment) 2 lastname 3 firstname And a table named t_books, fields inside: t_books: 1 bookid (primary key, auto_increment) 2 authorid (Typ:index, reference to authorid from