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]