Chapter 12. String Functions
We have already seen how we can pass the burden of certain processes onto the database server. The MySQL aggregate functions are optimized for their tasks. This reduces the amount of I/O passed back to Python and results in less data for our programs to process. In addition to the aggregate functions, MySQL also provides other functions that help us process data before it is returned to Python.
In this chapter, we will see:
- The way MySQL allows us to combine strings and return the single, resulting value
- How to extract part of a string or the location of a part, thus saving on processing
- How to convert cases of results
All of this can be done through MySQL for Python. After we have seen the common ways to juggle strings ...
Get MySQL for Python 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.
