Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Dokumen ini menjelaskan cara menginstal library fungsi MySQL yang telah ditentukan sebelumnya di database Spanner. Anda dapat menambahkan fungsi ini ke database menggunakan konsol Google Cloud atau Google Cloud CLI.
Dengan menginstal fungsi MySQL ini, Anda dapat memperluas kemampuan Spanner, sehingga Anda dapat melakukan operasi yang umum di lingkungan MySQL langsung dalam Spanner.
Untuk mengetahui informasi selengkapnya tentang fungsi MySQL yang didukung Spanner, lihat Fungsi MySQL.
Peran yang diperlukan
Untuk mendapatkan izin yang diperlukan untuk menginstal fungsi MySQL, minta administrator Anda untuk memberi Anda peran IAM Cloud Spanner Database Admin (roles/spanner.databaseAdmin) di project Anda.
Untuk mengetahui informasi selengkapnya tentang cara memberikan peran, lihat Mengelola akses ke project, folder, dan organisasi.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-05 UTC."],[],[],null,["# Install MySQL user-defined functions\n\nThis document describes how to install a predefined library of MySQL functions\nin a Spanner database. You can add these functions to your\ndatabase using the Google Cloud console or the Google Cloud CLI.\n\nInstalling these MySQL functions extends Spanner's capabilities,\nallowing you to perform operations that are common in MySQL environments\ndirectly within Spanner.\n\nFor more information about the MySQL functions that Spanner\nsupports, see [MySQL functions](/spanner/docs/reference/mysql/user_defined_functions_all).\n\nRequired roles\n--------------\n\n\nTo get the permissions that\nyou need to install the MySQL functions,\n\nask your administrator to grant you the\n\n\n[Cloud Spanner Database Admin](/iam/docs/roles-permissions/spanner#spanner.databaseAdmin) (`roles/spanner.databaseAdmin`)\nIAM role on your project.\n\n\nFor more information about granting roles, see [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n\n\nYou might also be able to get\nthe required permissions through [custom\nroles](/iam/docs/creating-custom-roles) or other [predefined\nroles](/iam/docs/roles-overview#predefined).\n\nInstall the MySQL user-defined functions\n----------------------------------------\n\nYou can install the MySQL user-defined functions in a Spanner\ndatabase in the following ways: \n\n### Google Cloud console\n\n1. In the Google Cloud console, go to the Spanner **Instances** page.\n\n [Go to the Instances page](https://console.cloud.google.com/spanner/instances)\n2. Click the instance containing the database.\n\n3. Click the database.\n\n4. Click the **Write DDL** button to open Spanner Studio.\n\n5. Copy the entire content of the DDL file in the [`mysql_udfs.sql`](https://github.com/googleapis/spanner-sql-udf/blob/main/mysql/mysql_udfs.sql)\n file.\n\n6. In a SQL editor tab, paste the copied content from the DDL file,\n\n7. Click **Run**.\n\n### gcloud\n\nYou can use the [`gcloud spanner database ddl update`](/sdk/gcloud/reference/spanner/databases/ddl/update)\ncommand to install the MySQL UDFs.\n\n\nBefore using any of the command data below,\nmake the following replacements:\n\n- \u003cvar class=\"edit\" scope=\"DATABASE_ID\" translate=\"no\"\u003eDATABASE_ID\u003c/var\u003e: the ID of the database to add the MySQL UDFs.\n- \u003cvar class=\"edit\" scope=\"INSTANCE_ID\" translate=\"no\"\u003eINSTANCE_ID\u003c/var\u003e: the ID of the instance where the database is located.\n- \u003cvar class=\"edit\" scope=\"DDL_FILE_PATH\" translate=\"no\"\u003eDDL_FILE_PATH\u003c/var\u003e: path to a file containing all the `CREATE OR REPLACE FUNCTION` statements in the [mysql_udfs.sql](https://github.com/googleapis/spanner-sql-udf/blob/main/mysql/mysql_udfs.sql) file.\n\n\nExecute the\n\nfollowing\n\ncommand:\n\n#### Linux, macOS, or Cloud Shell\n\n**Note:** Ensure you have initialized the Google Cloud CLI with authentication and a project by running either [gcloud init](/sdk/gcloud/reference/init); or [gcloud auth login](/sdk/gcloud/reference/auth/login) and [gcloud config set project](/sdk/gcloud/reference/config/set). \n\n```bash\ngcloud spanner databases ddl update DATABASE_ID \\\n--instance=INSTANCE_ID \\\n--ddl-file=DDL_FILE_PATH\n```\n\n#### Windows (PowerShell)\n\n**Note:** Ensure you have initialized the Google Cloud CLI with authentication and a project by running either [gcloud init](/sdk/gcloud/reference/init); or [gcloud auth login](/sdk/gcloud/reference/auth/login) and [gcloud config set project](/sdk/gcloud/reference/config/set). \n\n```bash\ngcloud spanner databases ddl update DATABASE_ID `\n--instance=INSTANCE_ID `\n--ddl-file=DDL_FILE_PATH\n```\n\n#### Windows (cmd.exe)\n\n**Note:** Ensure you have initialized the Google Cloud CLI with authentication and a project by running either [gcloud init](/sdk/gcloud/reference/init); or [gcloud auth login](/sdk/gcloud/reference/auth/login) and [gcloud config set project](/sdk/gcloud/reference/config/set). \n\n```bash\ngcloud spanner databases ddl update DATABASE_ID ^\n--instance=INSTANCE_ID ^\n--ddl-file=DDL_FILE_PATH\n```\n\n\u003cbr /\u003e\n\nWhat's next\n-----------\n\n- Learn about all the Spanner supported [MySQL user-defined functions](/spanner/docs/reference/mysql/user_defined_functions_all)."]]
