Search Results
https://dev.mysql.com/doc/internals/en/select-derived.html
If lex->derived_tables flag is present, all SELECT_LEX structures will be scanned (there is a list of all SELECT_LEX structures in reverse order named lex->all_selects_list, the first SELECT in the query will be last in this list). For any table ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-error-handling.html
This section provides information about MGM API functions used for error handling. The MGM API includes functions to obtain this information in the event of an error. ndb_mgm_get_latest_error() ndb_mgm_get_latest_error_msg() ...Each MGM API error ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-management-server-handles.html
This section provides information about MGM API functions used to create and destroy management server handles (see NdbMgmHandle). ndb_mgm_create_handle() ndb_mgm_set_name() ndb_mgm_set_ignore_sigpipe() ndb_mgm_destroy_handle() ...
https://dev.mysql.com/doc/ndbapi/en/overview-ndbinterpretedcode-using.html
Note This is the same regular expression pattern syntax that is supported by NdbScanFilter; see NdbScanFilter::cmp(), for more information. On x86, this is the first byte (byte 0); on SPARC and PPC, it is the last byte. Method Buffer (words) Request ... The next few sections provide information about performing different types of operations with NdbInterpretedCode methods, including resource ...
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-14.html
This enables you to remove entries for clusters, topologies, agents, hosts, and instances which were monitored, but are no longer in use. For more information, see Asset Management Important Change: As of this release, to install MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-secure-connections.html
This section describes configuring the server for secure connections and distributing client certificate and keys files. You can make this configuration more restrictive by setting the bind_address configuration option to a specific IPv4 or IPv6 ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-sql.html
If you remember your manual, you know that you must pronounce this: ess queue ell. The "parser" programs on mysql-5.0/sql: size name comment ---- ---- ------- 51326 sql_lex.cc lexer 230026 sql_yacc.yy parser + many more *.cc programs This is where ...In other words, programs like sql_lex.cc and sql_yacc.yy are responsible for figuring out what's in an SQL command, and deciding what to do about ...
https://dev.mysql.com/doc/internals/en/optimizer-not-relations.html
It is a logical rule that column1 <> 5 is the same as column1 < 5 OR column1 > 5 However, MySQL does not transform in this circumstance. If you think that a range search would be better, then you should do your own transforming in such cases. It is ...
https://dev.mysql.com/doc/internals/en/optimizer-union-queries.html
Therefore, for this query: SELECT * FROM Table1 WHERE column1 = 'x' UNION ALL SELECT * FROM TABLE1 WHERE column2 = 'y' if both column1 and column2 are indexed, then each SELECT is done using an indexed search, and the result sets are merged. Notice ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-myisam-fk.html
In this case, relationship lines between foreign keys in the table will automatically be drawn. This graphical representation makes the relationships between the tables much easier to understand. This means that MyISAM tables that are reverse ...