Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
--connections=# Command-Line Format --connections=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 Number of cluster connections to create. --resume Command-Line Format --resume If a job is aborted (due to a temporary db error ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/show.html
In SHOW statement results, user names and host names are quoted using backticks (`). SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
-DSYSTEMD_PID_DIR=dir_name The name of the directory in which to create the PID file when MySQL is managed by systemd. -DREPRODUCIBLE_BUILD=bool For builds on Linux systems, this option controls whether to take extra care to create a build result ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually-how-to.html
CREATE TABLE Statement Depending on the version of MySQL you are using, use the appropriate CREATE TABLE statement. As of MySQL 9.4.0, you can use the CREATE EXTERNAL TABLE statement, which automatically sets ENGINE to lakehouse, and ... If you ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
You can also create custom listeners to allow trace messages to be written to other destinations as mobile devices and web services. The first thing you need to do is create a suitable app.config file for your application. mysql Information: 1 : 1: ... The .NET tracing architecture consists of four main parts: Source - This is the originator of the trace ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-stored-procedures.html
Before working through this tutorial, familiarize yourself with the CREATE PROCEDURE and CREATE FUNCTION statements that create different kinds of stored routines. For the purposes of this tutorial, you will create a simple stored procedure to see ...Putting database-intensive operations into stored procedures lets you define an API for your database ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
Before working through this tutorial, familiarize yourself with the CREATE PROCEDURE and CREATE FUNCTION statements that create different kinds of stored routines. For the purposes of this tutorial, you will create a simple stored procedure to see ...Putting database-intensive operations into stored procedures lets you define an API for your database ...