Member Avatar for Geertc

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
  • 82 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by Geertc
Member Avatar for Geertc

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.