Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
This is because ExecuteNonQuery is only used for inserting, updating and deleting data. When a connection has been established with the MySQL database, the next step enables you to perform database operations. This task can be achieved through the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-reference-errorcodes.html
The following tables lists the error codes returned by Connector/ODBC apart from the server errors.
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/binary-log-overview.html
It also contains statements that potentially could have updated it (for example, a DELETE which matched no rows), unless row-based logging is used. There are two types of binary logging: Statement-based logging: Events contain SQL statements that ...
https://dev.mysql.com/doc/internals/en/full-text-search.html
Every time that insert/update/delete occurs for any row in the table, these global weight factors change for all rows in the table. It would take too long to replace the weights for all keys in the fulltext index, for every single ... MySQL uses ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-sql.html
Thus, there are "statement" routines like sql_delete.c, sql_load.c, and sql_help.c, which take care of the DELETE, LOAD DATA, and HELP statements. If you remember your manual, you know that you must pronounce this: ess queue ell. The "parser" ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
Will be included in the TABLE structure */ handler(TABLE *table_arg) : table(table_arg),active_index(MAX_REF_PARTS), ref(0),ref_length(sizeof(my_off_t)), block_size(0),records(0),deleted(0), data_file_length(0), max_data_file_length(0), ... And now ...
https://dev.mysql.com/doc/internals/en/implementing-the-info-method.html
delete_length - check_time - When calculating values, speed is more important than accuracy, as there is no sense in taking a long time to give the optimizer clues as to what approach may be the fastest. The optimizer requests an update of table ...
https://dev.mysql.com/doc/internals/en/innodb-page-example.html
For this example, I used Borland's TDUMP again, as I did for the earlier chapter on Record Format. This is what a page looked like: Address Values in Hexadecimal Values in ASCII 0D4000: 00 00 00 00 00 00 00 35 FF FF FF FF FF FF FF FF ...
https://dev.mysql.com/doc/internals/en/innodb-page-header.html
The PAGE_FREE pointer in the page header points to the first record in the list. The "next" pointer in the record header (specifically, in the record's Extra Bytes) points to the next record in the list. PAGE_DIRECTION and PAGE_N_DIRECTION: It's ...