Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
If CommandType is set to TableDirect, all rows and columns of the named table are returned when you call one of the execute methods. In effect, this command performs a SELECT * on the table specified. The CommandText property is set to the name of ... The MySqlCommand class represents a SQL statement to execute against a MySQL ...
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-examples-programming-vb-rdo.html
The following RDO (Remote Data Objects) example creates a table my_rdo and demonstrates the use of rs.addNew and rs.update. SQL = "select * from my_rdo" Set rs = cn.OpenResultset(SQL, rdOpenStatic, rdConcurRowVer, rdExecDirect) Do Until rs.EOF For ...
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
EXEC_LOAD_EVENT tells the slave to load the temporary file into the table, or DELETE_FILE_EVENT tells the slave not to do the load and to delete the temporary file. LOAD DATA INFILE is not written to the binary log like other statements. It is ...
https://dev.mysql.com/doc/internals/en/optimizer-group-by-related-conditions.html
If the table handler has a quick row-count available, then the query SELECT COUNT(*) FROM Table1; gets the count without going through all the rows. This is true for MyISAM tables, but not for InnoDB tables. Note that the query SELECT COUNT(column1) ... These are the main optimizations that take place for GROUP BY and related items (HAVING, COUNT(), MAX(), MIN(), SUM(), AVG(), ...
https://dev.mysql.com/doc/internals/en/replication-not-guaranteed.html
(P-exception-federated) If a table uses a federated table on the master, then TODO (P-exception-table-definition) If a CREATE TABLE uses a DATA DIRECTORY or INDEX DIRECTORY clause, then the table may not be correctly replicated. There are some ...
https://dev.mysql.com/doc/internals/en/replication-source-code-files.html
rpl_record.h/.cc Utilities for encoding and decoding table rows into and out of the row event format. rpl_filter.h/.cc Implements the table and database filters used by the --{binlog,replicate}-{do,ignore}-db, --replicate[-wild]-{do,ignore}-table, ... Status of this section: up to date 2009-12-16 Files in the sql directory: File Description slave.h/.cc Contains the slave IO and SQL ...
https://dev.mysql.com/doc/internals/en/source-directory-listing.html
Directory — Short Comment bdb — The Berkeley Database table handler BitKeeper — BitKeeper administration (not part of the source distribution) BUILD — Frequently used build scripts client — Client library cmd-line-utils — Command-line ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-persistent.html
Table 4.94 column Parameter Description return the name of the column 4.3.2.13.3 extensions Non-standard extensions for this member. Table 4.95 extensions Parameter Description return the non-standard extensions 4.3.2.13.4 nullValue Behavior when ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-22.html
(Bug #31337609, Bug #99523) Entity Framework code-first migration omitted the schema attribute that was assigned to an entity, although the automatic migration appeared to generate a table with the proper schema value at first. (Bug #31304070, Bug ... Deprecation and Removal Notes Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes The following synonyms for the Server connection string option were deprecated in Connector/NET 8.0.22 and removed in 8.0.23: address, addr, and network ...