> 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?
Update with information I forgot to mention: using MyISAM tables for this. Also, the table is a MERGED table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
