Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). NDB Cluster stores foreign key names using the same lettercase with which they are created. Creating a foreign key constraint requires ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Review the following examples for different ways to create external ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. Note NDB Cluster never saves the user-furnished password or generated encryption key. In this case, the management client prompts the user for a password.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) to specify files when creating external tables manually. Create the external tables that will ingest the loaded data by either using SQL syntax or JSON ...You can also use name, prefix, or pattern parameters to specify files in the bucket or Object Storage ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-php-pdo.html
$e->getMessage(); } """ % params mforms.Utilities.set_clipboard_text(text) mforms.App.get().set_status_text("Copied PHP code to clipboard") return 0 This simple plugin generates PHP code to create a MySQL connection using PHP's PDO_MySQL extension.
https://dev.mysql.com/doc/connectors/en/connector-python-example-ddl.html
The following examples show how to create the tables of the Employee Sample Database. You might typically work with tables that are already set up, rather than creating them within your own application. The exception is temporary tables, which can ... All DDL (Data Definition Language) statements are executed using a handle structure known as a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
The following examples show how to create the tables of the Employee Sample Database. You might typically work with tables that are already set up, rather than creating them within your own application. The exception is temporary tables, which can ... All DDL (Data Definition Language) statements are executed using a handle structure known as a ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
In such a setup, applications and users would not get any access to the database tables directly, but can only execute specific stored procedures. This section does not provide in-depth information on creating stored procedures. For example, to ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
In such a setup, applications and users would not get any access to the database tables directly, but can only execute specific stored procedures. This section does not provide in-depth information on creating stored procedures. For example, to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Compressed tables can be created in file-per-table tablespaces or in general tablespaces.