0

hello,

for my application I have created a database containing a table where my clients data is stored before they are allowed to use the website.
When they are allowed, the info on this table has to be transferred to 3 different tables, using the insert...select-statement. Doing this I don't want to transfer the ID from this table into the others ; instead, I want to insert the data into the first table, with its own ID, and then use this ID as a foreign key into the other 2 tables.
Has anyone an idea how to construct this or these query's ?
Thank you for spending time on this !

Geertc

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by Geertc
0

hello,

I'm afraid I was a bit to quick starting a new thread. I found the answer in the mysql manual. I guess you can say : thread solved.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.