Search Results
https://dev.mysql.com/doc/refman/8.4/en/component-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/other-administrative-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/sql-data-definition-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/sql-data-manipulation-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/sql-server-administration-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/sql-utility-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/table-maintenance-statements.html
...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-function-descriptions.html
To prepare and execute queries, use the functions described in detail in the following sections. All functions that operate with a MYSQL_STMT structure begin with the prefix mysql_stmt_.
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
For optimal performance with DML statements, InnoDB requires an index to exist on foreign key columns, so that UPDATE and DELETE operations on a parent table can easily check whether corresponding rows exist in the child table. MySQL creates or ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
An index must be dropped and added back with the desired change, which can be performed in a single ALTER TABLE statement. For details about permissible index_option values, see Section 15.1.15, “CREATE INDEX Statement”. old_index_name must be ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...