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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
