Advanced Tutorial

[audiopro]

I am slowly getting to grips with MySQL but I need a little bit of guidance. I have visited numerous tutorial sites and they mostly deal with queries and results.
Are there vars in MySQL which return info such as 'number of matching records', 'No matches found', 'nothing written to table' etc. or have these to be tested for?

Keith

http://www.studiosoft.co.uk

 

[TonyGroves]

You can use "SHOW WARNINGS;" to get the warnings relating to the last statement that produced warnings. However, this would not include routine information such as number of rows matched. That information can be obtained from facilities provided by whichever programming API you're using. For example, in the C API, you can use mysql_info() and mysql_affected_rows() to get more information about the most recent query.