Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-call-statements.html
This section describes prepared-statement support in the C API for stored procedures executed using CALL statements: Stored procedures executed using prepared CALL statements can be used in the following ways: A stored procedure can produce any ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
An API provides a stable set of names and types for functions, procedures, parameters, and return values. Historically, used by some Connector/J, Connector/ODBC, and Connector/PHP developers to work around issues with server-side stored procedures.
https://dev.mysql.com/doc/c-api/8.4/en/mysql-drop-db.html
int mysql_drop_db(MYSQL *mysql, const char *db) Description Drops the database named by the db parameter. Use mysql_real_query() or mysql_query() to issue an SQL DROP DATABASE statement instead. Example if(mysql_drop_db(&mysql, "my_database")) ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. Dropping a partition from a table that is partitioned by either RANGE or by LIST can be ...For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
Stored routines can be dropped with the DROP PROCEDURE and DROP FUNCTION statements (see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”), and altered with the ALTER PROCEDURE and ALTER FUNCTION statements (see Section 15.1.7, ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
Supported table DDL statements include CREATE, ALTER, and DROP statements for databases, tablespaces, tables, and indexes, and the TRUNCATE TABLE statement. Supported non-table DDL statements include: CREATE and DROP statements, and, if applicable, ...An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic ...
https://dev.mysql.com/doc/refman/8.4/en/general-tablespaces.html
Dropping a General Tablespace The DROP TABLESPACE statement is used to drop an InnoDB general tablespace. All tables must be dropped from the tablespace prior to a DROP TABLESPACE operation. If the tablespace is not empty, DROP TABLESPACE returns an ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...
https://dev.mysql.com/doc/internals/en/com-drop-db.html
COM_DROP_DB: drop a schema Payload 1 [06] COM_DROP_DB string[EOF] schema name Returns OK_Packet or ERR_Packet Example 05 00 00 00 06 74 65 73 74 .....test .
https://dev.mysql.com/doc/refman/8.4/en/sys-list-drop.html
Removes a value from a comma-separated list of values and returns the result. For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified.
https://dev.mysql.com/doc/x-devapi-userguide/en/using-sql.html
The following example uses a Session to call an SQL Stored Procedure on the specific node. In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string.