Search Results
https://dev.mysql.com/doc/workbench/en/wb-table-editor-triggers-tab.html
All triggers are organized within a tree structure by section, such as BEFORE INSERT and AFTER INSERT. The Triggers subtab opens a workspace that enables you to create new triggers or edit existing triggers. To add a new trigger, click the [+] icon ...
https://dev.mysql.com/doc/workbench/en/wb-using-table-tool.html
Tables can also be added to an EER Diagram using the table tool on the vertical toolbar. Make sure that the EER Diagram tab is selected, then right-click the table icon on the vertical toolbar. Clicking the mouse on this icon changes the mouse ...
https://dev.mysql.com/doc/connectors/en/connector-j-schema-validation.html
When working with MySQL Server 8.0.19 and later: Schema validation can be configured for a Collection, so that documents in the Collection are validated against a schema before they can be inserted or updated. Attempting to insert or modify a ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-api.html
(Useful for long data values.) Table 5.10 ODBC API Calls for Retrieving Results and Information about Results Function Name Connector/ODBC Supports? Standard Purpose SQLRowCount Yes ISO 92 Returns the number of rows affected by an insert, update, or ...For the complete ODBC API reference, please refer to the ODBC Programmer's Reference at ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-dao.html
The following DAO (Data Access Objects) example creates a table my_dao and demonstrates the use of rs.addNew, rs.update, and result set scrolling. Set rs = conn.OpenRecordset("my_dao") rs.Edit rs!Name = "updated-string" rs.Update rs.Close 'fetch ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-api.html
(Useful for long data values.) Table 7.6 ODBC API Calls for Retrieving Results and Information about Results Function Name Connector/ODBC Supports? Standard Purpose SQLRowCount Yes ISO 92 Returns the number of rows affected by an insert, update, or ...For the complete ODBC API reference, please refer to the ODBC Programmer's Reference at ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-affected-rows.html
Syntax: count = ccnx.affected_rows() Returns the number of rows changed, inserted, or deleted by the most recent UPDATE, INSERT, or DELETE statement.
https://dev.mysql.com/doc/internals/en/error-flags.html
(This allows one to catch all error messages generated by a statement) thd->lex->current_select->no_error This is set to in case likes INSERT IGNORE ... thd->count_cuted_fields If set, we generate warning for field conversations (normal case for ...
https://dev.mysql.com/doc/internals/en/myisam-dynamic-data-file-layout.html
When a record is inserted after this, it reuses the old frame. The rest is inserted in other old frames, or, if non is available, in a new frame at end of file. A record can be put in one or more frames, also called the record "parts" or "blocks".
https://dev.mysql.com/doc/internals/en/packet-OK_Packet.html
An OK packet is sent from the server to the client to signal successful completion of a command. As of MySQL 5.7.5, OK packes are also used to indicate EOF, and EOF packets are deprecated. Consequently, the server does not send OK packets that ...