|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
This is a total novice, total newbie, total loser of an enquiry.
I need the tables in my database to be linked through one-to-many relationships, only I don't know how... For example, I have Table one, Field A Table two, Field A When I add records to Field A in Table One, I want Field A in Table Two to update with the same data. I'm using MySQL CC and MySQL Front at the moment and I can't see how to do it. I created Field A in both tables, with the same properties in each.. and that's as far as I can see to go.. It's probably staring me right in the face, but my dumb ass is just too dumb. I'm prepared to download other software if anyone can recommend anything that will make it easier. It would be much appreciated if you could start me off with the SQL query coding.. if you could.. Please assist... Thanks. EDIT: After doing a little research, it appears that it is possible to enter all the details in, for example, Field A in Table One, then to have a query duplicate the data into Field A in Table Two. Can anyone help me out with doing this? I will love you long time. |
|
#2
|
||||
|
||||
|
Why would you want to fill two tables with the same data? That doesn't sound right.
|
|
#3
|
|||
|
|||
|
No no.. it's not just Field A in the two tables.. I have other fields too.. I just simplified to make it easier to understand; obviously it didn't do as intended. Sorry.
EDIT: After doing a little research, it appears that it is possible to enter all the details in, for example, Field A in Table One, then to have a query duplicate the data into Field A in Table Two. Can anyone help me out with doing this? I will love you long time. |
|
#4
|
||||
|
||||
|
You have to do it in two statements. You would wrap these two statements in a Stored Procedure.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > DB relationship question [newbie] |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|