I'm quite new to mysql, and though I have read quite thuroughly several different books, and a number of tutorials, one thing
continues to escape me.
Since we can "join" data from multiple tables for display purposes, can't we do essentially the reverse?
Given the Normalization Process, it's necessary to break a database down into smaller tables, each "interconnected" via id's etc..
Were my question comes in, is when go to insert data into those tables, obviously from one form.. what's the approach there?
Is there a method for inserting data into multiple tables in one fail swoop? instead of doing them one by one?
Any information on this, live tutorials, etc.. would be very very helpful.. this seems to be the only confusion I have at this point.. well.. not exactly the other one is sorta wrapped into that one, and it deals with "incrementing" the row identifiers between tables, since it appears that only one column in a table can be "auto incremented".. so I'm a little lost on that aspect of it.. after all a table may contain multiple id fields, one for it's rows, and one or more which links it to other tables/rows.
Low Cost Hosting and Web Development.