MySQL Connector/C++ 9.1.0
MySQL connector library for C and C++ applications
Classes
table_crud.h File Reference

Crud operations on tables. More...

Go to the source code of this file.

Classes

class  TableInsert
 An operation which inserts rows into a table. More...
 
class  TableSelect
 An operation which selects rows from a table. More...
 
class  TableUpdate
 An operation which updates rows stored in a table. More...
 
class  TableRemove
 An operation which removes rows from a table. More...
 

Detailed Description

Crud operations on tables.

Classes declared here represent CRUD operations on a table. They are analogous to collection CRUD operation classes defined in collection_crud.h.

The following classes for table CRUD operations are defined:

CRUD operation objects can be created directly, or assigned from result of DevAPI methods that create such operations:

TableInsert insert_op(table);
TableSelect select_op = table.select(...).orderBy(...);

CRUD operation objects have methods which can modify the operation before it gets executed. For example TableInsert::values() appends a row to the list of rows that should be inserted into a table by the given TableInsert operation. These methods can be chained as allowed by the fluent API grammar.