Miscellaneous Topics

This section covers several subjects that didn't fit very well into the progression as we went from client1 to client5:

  • Using result set data to calculate a result, after using result set metadata to help verify that the data are suitable for your calculations.

  • How to deal with data that are troublesome to insert into queries.

  • How to work with image data.

  • How to get information about the structure of your tables.

  • Common MySQL programming mistakes and how to avoid them.

Performing Calculations on Result Sets

So far we've concentrated on using result set metadata primarily for printing row data, but clearly there will be times when you need to do something with your data besides print it. For example, you can compute statistical ...

Get MySQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.