# OTL 4.0, Examples for MySQL / MyODBC 3.5

The examples below work with MySQL via MyODBC 3.5. In general, all of these examples should work with any more or less recent versions of MySQL, when ODBC is enabled in OTL by setting #define OTL_ODBC. For more examples, see the Generic ODBC examples.

1. Example 225 (Simple Insert/Select/Update, MyODBC 3.50)
2. Example 226 ("Incompatible datatypes in stream operation" exception, MyODBC 3.50)
3. Example 227 (otl_datetime container and datetime/date table columns, MyODBC 3.50)
4. Example 228 (otl_long_string container and LONGTEXT column, MyODBC 3.50)
5. Example 229 (otl_long_string container and LONGBLOB column, MyODBC 3.50)
6. Example 230 (std::string and STL-compliant stream iterators, MyODBC 3.50)
7. Example 231 (otl_stream::describe_select() with a simple Select, MyODBC 3.50)
8. Example 344 (otl_stream_read_iterator, "get by name" functions, MySQL)
9. Example 375 (Simple Insert/Select, otl_connect::operator<<, <<=, >>)
10. Example 382 (Insert/Update/Select, MySQL LONGTEXT in stream mode, and std:strings)
11. Example 391 (Insert/Update/Select with MySQL LONGTEXT in stream mode, without otl_lob_stream::set_len())
12. Example 392 (Insert/Update/Select with MySQL LONGBLOB in stream mode, without otl_lob_stream::set_len())
13. Example 452 (Simple Insert/Select with VARBINARY datatype)
14. Example 453 (Simple Insert/Select with BINARY datatype)
15. Example 463 (Simple Insert/Select with VARBINARY datatype and otl_stream_read_iterator)
16. Example 464 (Simple Insert/Select with BINARY datatype and otl_stream_read_iterator)

Prev Next Contents Go Home

Copyright © 1996, 2007, Sergei Kuchin, email: skuchin@ispwest.com, skuchin@gmail.com
.

Permission to use, copy, modify and redistribute this document for any purpose is hereby granted without fee, provided that the above copyright notice appear in all copies.