1
MySQL++ v3.2.3 User Manual
Kevin Atkinson
Sinisa Milivojevic
Monty Widenius
Warren Young
Copyright © 1998-2001, 2005-2015 Kevin Atkinson (original
author), MySQL AB, Educational Technology Resources
December 30, 2016
Table of Contents
1. Introduction .................................................................................................................................... 3
1.1. A Brief History of MySQL++ ................................................................................................. 3
1.2. If You Have Questions... ........................................................................................................ 4
2. Overview ....................................................................................................................................... 5
2.1. The Connection Object .......................................................................................................... 5
2.2. The Query Object ................................................................................................................. 5
2.3. Result Sets ........................................................................................................................... 5
2.4. Exceptions ........................................................................................................................... 7
3. Tutorial .......................................................................................................................................... 8
3.1. Running the Examples ........................................................................................................... 8
3.2. A Simple Example ................................................................................................................ 9
3.3. A More Complicated Example ............................................................................................... 10
3.4. Exceptions ......................................................................................................................... 11
3.5. Quoting and Escaping .......................................................................................................... 12
3.6. C++ vs. SQL Data Types ..................................................................................................... 13
3.7. Handling SQL Nulls ............................................................................................................ 14
3.8. MySQL++’s Special String Types .......................................................................................... 15
3.9. Dealing with Binary Data ..................................................................................................... 17
3.10. Using Transactions ............................................................................................................. 22
3.11. Which Query Type to Use? ................................................................................................. 25
3.12. Conditional Result Row Handling ........................................................................................ 27
3.13. Executing Code for Each Row In a Result Set ........................................................................ 29
3.14. Connection Options ............................................................................................................ 30
3.15. Dealing with Connection Timeouts ....................................................................................... 33
3.16. Concurrent Queries on a Connection ..................................................................................... 34
3.17. Getting Field Meta-Information ............................................................................................ 35
4. Template Queries ........................................................................................................................... 38
4.1. Setting up Template Queries ................................................................................................. 39
4.2. Setting the Parameters at Execution Time ................................................................................ 40
4.3. Default Parameters .............................................................................................................. 40
4.4. Error Handling .................................................................................................................... 41
5. Specialized SQL Structures ............................................................................................................. 42
5.1. sql_create ........................................................................................................................... 42
5.2. SSQLS Comparison and Initialization ..................................................................................... 43
5.3. Retrieving data .................................................................................................................... 43