Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
The second example shows how you can retrieve the same value using a standard SELECT LAST_INSERT_ID() query. getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-php-pdo.html
MySQL Workbench includes a plugin that generates PHP code with the mysqli extension. This tutorial shows how to generate code with the PDO_MySQL extension for PHP. You might choose a different extension or a different language altogether, so adjust ...
https://dev.mysql.com/doc/internals/en/authentication-method-mismatch.html
Assume that client wants to log in as user U and that user account uses authentication method M. Note The missmatch can happen even if client and server used the same authentication method in the initial handshake, but this method was different ...
https://dev.mysql.com/doc/internals/en/transformations-row-in.html
To rewrite a row IN subquery, the method used is Item_in_subselect::row_value_transformer. It works in almost the same way as the scalar analog, but works with Item_cache_row for caching left expression and uses references for elements of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbinfo-select-all.html
--delay=seconds Command-Line Format --delay=# Type Numeric Default Value 5 Minimum Value 0 Maximum Value MAX_INT This option sets the number of seconds to wait between executing loops. --loops=number, -l number Command-Line Format --loops=# Type ...
https://dev.mysql.com/doc/internals/en/guided-tour-majordir-build.html
When it's done, you'll have an executable MySQL server and client. Sometimes people have trouble with this step because there's something missing in their operating system version, or whatever. It actually has very little in it, but it's useful, ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-autotools.html
It is often faster and simpler to use GNU autotools than to write your own makefiles. In this section, we provide an autoconf macro WITH_MYSQL that can be used to add a --with-mysql option to a configure file, and that automatically sets the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
Merging cached changes at a later time, when affected pages are read into the buffer pool by other operations, avoids substantial random access I/O that would be required to read secondary index pages into the buffer pool from disk. The change ...
https://dev.mysql.com/doc/workbench/en/wb-eer-diagrams-section.html
Enhanced Entity-Relationship (EER) diagrams are an essential part of the modeling interface in MySQL Workbench. EER diagrams provide a visual representation of the relationships among the tables in your model. Revisions made with the Model Editor ...
https://dev.mysql.com/doc/internals/en/optimizer-index-join-type.html
Consider this query: SELECT column1 FROM Table1; If column1 is indexed, then the optimizer may choose to retrieve the values from the index rather than from the table. An index which is used this way is called a covering index in most texts. For ...