Egor, Thank you , I wasn't sure anyone would ever respond to this post :)
What I wound up doing is , from the application level, running an if / else. The if checks to see if each $query has succeeded. If any of them failed, I do a rollback. If they all have succeeded, I then do a committ. Now I'm not totally sure how a rollback would effect the one Myisam query. I mean it wouldn't , since rollback is alien to myisam, so I probably need to put a line in there to (whatever a rollback is in myisam language) as well. Stuart --- Egor Egorov <[EMAIL PROTECTED]> wrote: > Stuart Felenstein <[EMAIL PROTECTED]> wrote: > > > I have a slight dilemma. I am using transactions > to > > insert data into multiple tables. All but one > table > > is Innodb. That one is Myisam and it's left as > such > > because its one text column, so I want the > benefits of > > full text search. > > > > Still I need this transaction to somehow include > this > > entry. > > Two thoughts : > > 1- I created a temp innodb table and then after > > transaction move the data over to the myisam. > > > > 2-Figure out what the text search options are in > > innodb and maybe if there is a way to improve on > them. > > > > Any suggestions ? > > Consider LOCK TABLES: > http://dev.mysql.com/doc/mysql/en/LOCK_TABLES.html > > > > > > -- > For technical support contracts, goto > https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net > http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
