MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 21 to 30 of 59 total results

21.5.26 ndb_select_count — Print Row Counts for NDB Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-count.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the ...

21.5.27 ndb_show_tables — Display List of NDB Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-show-tables.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_show_tables displays a list of all NDB database objects in the cluster. By default, this ...

21.5.29 ndb_top — View CPU usage information for NDB threads

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-top.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB ...

21.5.30 ndb_waiter — Wait for NDB Cluster to Reach a Given Status

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-waiter.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes ...

21.5.9 ndb_delete_all — Delete All Rows from an NDB Table

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-delete-all.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all ...

21.5.2 ndbinfo_select_all — Select From ndbinfo Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbinfo-select-all.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndbinfo_select_all is a client program that selects all rows and columns from one or more ...

13.2.9 SELECT Statement

https://dev.mysql.com/doc/refman/5.7/en/select.html

For example: SELECT CONCAT(last_name,', ',first_name) AS full_name FROM mytable ORDER BY full_name; The AS keyword is optional when aliasing a select_expr with an identifier. The preceding example could have been written like this: SELECT ... SELECT ...

21.5.11 ndb_drop_index — Drop Index from an NDB Table

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-index.html

--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). It is recommended that you use this utility only as an example for writing NDB API ...

12.10 Cast Functions and Operators

https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html

Casting the values to CHAR results in a lexical sort: SELECT enum_col FROM tbl_name ORDER BY CAST(enum_col AS CHAR); CAST() also changes the result if you use it as part of a more complex expression such as CONCAT('Date: ',CAST(NOW() AS DATE)). A ...

13.6.7.3 GET DIAGNOSTICS Statement

https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html

GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ... (You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The ...

Displaying 21 to 30 of 59 total results