Search Results
                    
                    
            https://dev.mysql.com/doc/refman/8.4/en/create-server.html
                                The CREATE SERVER statement creates a new row in the servers table in the mysql database. The CREATE SERVER statement creates an entry in the mysql.servers table that can later be used with the CREATE TABLE statement when creating a FEDERATED table. 
                                            
                https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
                                What happens to a view if an underlying table is dropped or renamed? A.6.4. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition ...Can you insert into views that are based on joins? ...
                                            
                https://dev.mysql.com/doc/refman/8.4/en/innodb-system-tablespace.html
                                 The system tablespace is the storage area for the change buffer. It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. By default, a single system tablespace data ...To do so, specify the autoextend attribute for the last data file in the innodb_data_file_path setting, and restart the ...
                                            
                https://dev.mysql.com/doc/refman/8.4/en/outer-join-simplification.html
                                 Table expressions in the FROM clause of a query are simplified in many cases. When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before ...At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join ...
                                            
                https://dev.mysql.com/doc/refman/8.4/en/serialized-dictionary-information.html
                                Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. Serialized dictionary information (SDI) is present in all InnoDB tablespace files except for temporary tablespace and undo ...
                                            
                https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
                                File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location. DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
                                            
                https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-vector-store-load.html
                                 The VECTOR_STORE_LOAD routine generates vector embedding for the specified files or folders that are , and loads the embeddings into a new vector store table. This routine creates an asynchronous task which loads vector store tables in the ...It ...
                                            
                https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-catalog-schema.html
                                Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
                                            
                https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-catalog-schema.html
                                Generally, catalogs are collections of schemas, so the fully qualified name would look like catalog.schema.table.column. In ODBC both schemas and catalogs can be used when referring to database objects such as tables. As a result the client software ... Many relational databases reference CATALOG and SCHEMA in ways that do not directly correspond to what MySQL refers to as a ...
                                            
                https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
                                 Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.