|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
From: Dan Nelson (dnelson
allantgroup.com)
Date: Sun Jul 26 2009 - 23:15:07 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
In the last episode (Jul 26), bufordbiffco.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
dnelsonallantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]