MySQL Shell API 8.4.3
Unified development interface for MySQL Products
|
Allows traversing the Row objects returned by a Table.select operation. More...
Methods | |
Row | fetchOne () |
Retrieves the next Row on the RowResult. More... | |
Dictionary | fetchOneObject () |
Retrieves the next Row on the result and returns it as an object. More... | |
List | fetchAll () |
Returns a list of DbDoc objects which contains an element for every unread document. More... | |
Integer | getColumnCount () |
Retrieves the number of columns on the current result. More... | |
List | getColumnNames () |
Gets the columns on the current result. More... | |
List | getColumns () |
Gets the column metadata for the columns on the active result. More... | |
Methods inherited from BaseResult | |
Integer | getAffectedItemsCount () |
The the number of affected items for the last operation. More... | |
Integer | getWarningsCount () |
The number of warnings produced by the last statement execution. More... | |
List | getWarnings () |
Retrieves the warnings generated by the executed operation. More... | |
String | getExecutionTime () |
Retrieves a string value indicating the execution time of the executed operation. | |
Properties | |
Integer | columnCount |
Same as getColumnCount() | |
List | columnNames |
Same as getColumnNames() | |
List | columns |
Same as getColumns() | |
Properties inherited from BaseResult | |
Integer | affectedItemsCount |
Same as getAffectedItemsCount() | |
Integer | warningsCount |
Same as getWarningsCount() | |
List | warnings |
Same as getWarnings() | |
String | executionTime |
Same as getExecutionTime() | |
Allows traversing the Row objects returned by a Table.select operation.
Row fetchOne | ( | ) |
Dictionary fetchOneObject | ( | ) |
Retrieves the next Row on the result and returns it as an object.
The column names will be used as keys in the returned dictionary and the column data will be used as the key values.
If a column is a valid identifier it will be accessible as an object attribute as <dict>.<column>.
If a column is not a valid identifier, it will be accessible as a dictionary key as <dict>[<column>].
List fetchAll | ( | ) |
Returns a list of DbDoc objects which contains an element for every unread document.
Integer getColumnCount | ( | ) |
Retrieves the number of columns on the current result.
List getColumnNames | ( | ) |
Gets the columns on the current result.
List getColumns | ( | ) |
Gets the column metadata for the columns on the active result.