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 ...
https://dev.mysql.com/doc/workbench/en/wb-tables-physical-schemata.html
Right-clicking a table opens a context menu with the following items: Cut 'table_name': Cut a table to optionally paste it into another schema. Copy 'table_name': Copy a table to optionally paste it into another schema. Copy Insert to Clipboard: ...
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/refman/9.7/en/alter-database.html
For a MERGE table such as CREATE TABLE s1.t(i int) ENGINE MERGE UNION (s2.t, s3.t), INSERT_METHOD=..., the following behavior applies: Inserting into the MERGE table (INSERT into s1.t) fails if at least one of s1, s2, s3 is read only, regardless of ...The insert is refused even if it would actually end up in a writable ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-consistent-read.html
The type of read varies for selects in clauses like INSERT INTO ... If you insert or modify some rows and then commit that transaction, a DELETE or UPDATE statement issued from another concurrent REPEATABLE READ transaction could affect those ... A ...
https://dev.mysql.com/doc/refman/9.7/en/range-optimization.html
Otherwise, any index on col_name is nonunique and the optimizer can estimate the row count for each range using dives into the index or index statistics. The idea is that if index use is forced, there is nothing to be gained from the additional ...
https://dev.mysql.com/doc/refman/9.7/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/9.7/en/join.html
This includes a join handled by merging derived tables and views in the FROM clause into the outer query block (see Section 10.2.2.4, “Optimizing Derived Tables, View References, and Common Table Expressions with Merging or Materialization”).
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
mysql Information: 1 : 1: Connection Opened: connection string = 'server=localhost;User Id=root;database=world;port=3306 ;password=******;logging=True' mysql Information: 3 : 1: Query Opened: SHOW VARIABLES mysql Information: 4 : 1: Resultset ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-single.html
Backup failed to insert file header (check configuration) 1346 MySQL error. Backup failed to insert table list (check configuration) 1347 MySQL error. Insert in hash table failed when getting table information from Ndb 4502 MySQL error. This ...