6 replies to this topic

[kwesiaryee]

Hi,

I have two related tables in mysql database and both use the same foreign key. I want to put both tables under one submit form so that the data supplied can go to both tables with no errors.

How can do that?

[Turk4n]

kwesiaryee said:

Hi,

I have two related tables in mysql database and both use the same foreign key. I want to put both tables under one submit form so that the data supplied can go to both tables with no errors.

How can do that?

I think you should visit the Java Help forum :)

http://forum.codecall.net/java-help/

[Turk4n]

Jordan said:

I've moved your thread, please do not post questions in the tutorial section. Thank you Turk4n for letting us know.

I moved your question to the Java section because you had it in the Java Tutorials section, however, your question involves MySQL which is commonly used in Web Development rather than desktop/Java development. What language are you trying to connect to the MySQL database with?

Np, Jordan and thanks for moving it !

[WingedPanther]

Just collect all the data you need, and then run the two insert statements.

[kwesiaryee]

I am connecting with java: connection pool to mysql

[morefood2001]

As winged said, you need 2 insert statements. Since you will be connecting to 2 tables, use the mysql table select command to select each table then insert the appropriate values.