RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://cloud.google.com/sql/docs/mysql/stored-procedures below:

Cloud SQL stored procedures | Cloud SQL for MySQL

Cloud SQL stored procedures

Stay organized with collections Save and categorize content based on your preferences.

This section describes stored procedures for Cloud SQL instances.

A stored procedure contains SQL code that you can reuse.

You cannot drop or alter system stored procedures.

To execute a stored procedure, you use the CALL command and replace the following variable:

procedure_name is the name of the stored procedure.

CALL procedure_name(parameters);

For more information, see the

CALL statement

reference page.

To create a stored procedure, see CREATE PROCEDURE and CREATE FUNCTION Statements. Cloud SQL doesn't support the CREATE FUNCTION statement. For more information, see Unsupported MySQL features for Cloud SQL.

Note: You cannot run some stored procedures because they require a sysadmin role, which isn't available in Cloud SQL. mysql.addSecondaryIdxOnReplica mysql.addSecondaryIdxOnReplica

Syntax

mysql.addSecondaryIdxOnReplica(IDXTYPE, IDXNAME, TABLENAME, IDXDEFINITION, IDXOPTION)

Description

Adds a secondary index on the database. This stored procedure is a wrapper for the CREATE INDEX DDL statement.

IDXTYPE – Type of index to create. For example, pass UNIQUE to create a unique index.
IDXNAME – Name of the index.
TABLENAME – Name of the table in the format of schema.name.
IDXDEFINITION – Definition of the index. Do not include outer parentheses.
IDXOPTION – Any additional options to pass on index creation. For example, in MySQL 8.0, an option could pass INVISIBLE for an invisible index.

mysql.dropSecondaryIdxOnReplica

Syntax

mysql.dropSecondaryIdxOnReplica(IDXNAME, TABLENAME, IDXOPTION)

Description

Drops a secondary index on the database. This stored procedure is a wrapper for the DROP INDEX DDL statement.

IDXNAME – Name of the index.
TABLENAME – Name of the table in the format of schema.name.
IDXOPTION – Any additional options to pass when dropping an index. For example, an algorithm option like INPLACE.

What's next

Learn how to add and drop indexes on Cloud SQL read replicas.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-08-14 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-14 UTC."],[],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4