This maybe somewhat of a silly question.  
Scenario - I am pretty much a noob at both relational
databases and web programming.  I've built most of my
pages using a RAD tool that, for the most part, does a
decent job , if you keep it fairly simple.

One of the limitations is inserts & updates are done
on a "one form on one page into one table" basis. 
There is a MtM feature.

Anyway, now I'm flying solo and have created a form
that spans 5 pages and will insert into (I lost count)
I believe 3-5 tables.  
I want to make sure I make provisions for rollback. 
All but one table is innodb.  

While Im reading and digging around, wondering is this
a massive insert statement ? Would joins need to be
involved ?  I'm imagining it's more of a step by step
(1 table at a time) process. 
With rollback, if an insertion is already done into 1
table , and the insert into table 2 fails, does that
mean table 1's insertion would be deleted ?

I think that is probably enough and I apologize for
asking what are basic questions and a bit scattered at
that.

Stuart


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to