Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete ...rs.Open "SELECT * FROM my_ado", conn Debug.Print rs.RecordCount rs.MoveFirst Debug.Print String(50, "-") & "Updated my_ado Result Set " & String(50, "-") For Each fld In rs.Fields Debug.Print fld.Name, Next Debug.Print Do Until rs.EOF For Each fld In rs.Fields Debug.Print fld.Value, Next rs.MoveNext Debug.Print Loop rs.Close conn.Close End ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-wordexcel.html
Within Microsoft Word, this facility is most useful when importing data for mailmerge, or for tables and data to be included in reports. You use Microsoft Query to build the SQL statement to be executed, selecting the tables, fields, selection ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-errors-error.html
This exception is the base class for all other exceptions in the errors module. It can be used to catch all errors in a single except statement. errors.Error is internally used by Connector/Python to raise MySQL client and server errors and should ...
https://dev.mysql.com/doc/internals/en/close.html
In sql_select.cc it is only used to close up temporary tables or during the process where a temporary table is converted over to being a MyISAM table. Synopsis virtual int close ( void); void ; Description This is the close method. A good time to ...
https://dev.mysql.com/doc/internals/en/create.html
Synopsis virtual int create ( name, form, info); const char * name ; TABLE * form ; HA_CREATE_INFO * info ; Description This is the create method. When create() is called you do not need to open the table. Usage Example from the CSV storage engine: ...Also, the .frm file will have already been created so adjusting create_info is not ...
https://dev.mysql.com/doc/internals/en/heap-directory.html
All the MySQL table handlers (that is, the handlers that MySQL itself produces) have files with similar names and functions. Thus, this (heap) directory contains a lot of duplication of the myisam directory (for the MyISAM table handler). Such ...
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
Some further random notes about the new format: In old tables (from MySQL 4.1 and earlier), VARCHAR columns have type MYSQL_TYPE_VAR_STRING, which works exactly like a CHAR with the exception that if you do an ALTER TABLE, it's converted to a true ... Next I'll describe the physical attributes of each column in a ...
https://dev.mysql.com/doc/internals/en/optimizer-early-nulls-filtering.html
Suppose further that table tblY is accessed via ref or eq_ref access on tblY.key_column = tblX.column or, in the case of ref access using multiple key parts, via ... We make the following inference: (tblY.key_partN = tblX.column) => (tblX.column IS ... Suppose we have a join order such as this one: ..., tblX, ..., tblY, ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
For purposes of defining "correct replication", the tables are considered equal if they are equal on the common columns. Note: For purposes of defining "correct replication", the tables are considered equal if they are equal on the common columns.
https://dev.mysql.com/doc/internals/en/store-lock.html
The idea with handler::store_lock() is the following: The statement decided which locks we should need for the table for updates/deletes/inserts we get WRITE locks, for SELECT... Before adding the lock into the table lock handler mysqld calls store ...Synopsis virtual THR_LOCK_DATA ** store_lock ( thd, to, lock_type); THD * thd ; THR_LOCK_DATA ** to ; enum thr_lock_type lock_type ; Description This is the store_lock ...