PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
Similarly, the cursor definition in the following procedure contains a SELECT statement that refers to xname. The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. You can find more detailed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
The number of bytes shown as Free extent_space is available for storing on-disk column data from the fish table only; for this reason, it is not visible when selecting from the Information Schema FILES table. --ndb-optimized-node-selection ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-index.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection Enable optimizations for selection of nodes for transactions. It is recommended that you use this utility only as an example for writing NDB API applications—see the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
Go to the console window properties, select the font tab, and choose Lucida Console or some other compatible Unicode font. For example, longer text values that include newlines often are much easier to read with vertical output: mysql> SELECT * FROM ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
The permissible values are read (scan tables), write (insert into tables), key (read primary keys), update (update primary keys), or mixed (half inserts, half scanning selects). For example, if you run a key test that performs 1000 selects, you can ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-range.html
The SELECT statement in the preceding example could also have been written using explicit row constructors, like this: SELECT ROW(5,10) < ROW(5,12), ROW(5,11) < ROW(5,12), ROW(5,12) < ROW(5,12); For more information about the use of row constructors ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
For example, you can retrieve numeric values from a SET column like this: mysql> SELECT set_col+0 FROM tbl_name; If a number is stored into a SET column, the bits that are set in the binary representation of the number determine the set members in ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html
mysql> SET @pt1 = ST_GeomFromText('POINT(0 0)'); mysql> SET @pt2 = ST_GeomFromText('POINT(1 1)'); mysql> SELECT ST_AsText(ST_MakeEnvelope(@pt1, @pt2)); +----------------------------------------+ | ST_AsText(ST_MakeEnvelope(@pt1, @pt2)) | ... The ...