In the last episode (Jul 26), buf...@biffco.net said: > Using version 5.0.6x on RH. The question I have is about the updating of > indexes. > > Say I have a table with a primary key and one or more indexes. I run an > INSERT statement by way of a call to mysql_real_query() in the C api. If > that function call returns zero, i.e., indicating success, does that mean > that everything is guaranteed to be completed? In particular that all the > table indexes have been updated, so that an immediately-subsequent SELECT > statement with an appropriate WHERE clause seeking for the same row will > find it using the index?
Yes. -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org