I have a simple table, few records for testing. there 4 indexes defined.
when issuing:
SELECT reg_data FROM test_table

but the following:
SELECT MAX(reg_data) FROM test_table
gives no result neither error msg

Questions:

1.How to retrieve the maximum (last) value of an autoincrement field?

2.where to find the result codes
of a search.?
I need to know if there was no data found or if something else happened

3. if no INDEX claused is specified,
does mysql use the PRIMARY or uses no indexes?

thanks a lot!