Search Results
https://dev.mysql.com/doc/refman/8.4/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. Optionally, the DBD module for any other type of database server you want to access. It ...To use DBI with MySQL, install the following: The DBI ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. These events bring databases up to date from the point of the backup. The term “binary log file” generally denotes ...It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows), unless row-based logging is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
Different methods can be used to compare resolution column values on the replica when conflicts occur, as explained later in this section; the method used can be set to act on a single table, database, or server, or on a set of one or more tables ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
Every database change (DDL or DML) that is written to the binary log is assigned a GTID. A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. Using prepared ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links.html
You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...For InnoDB tables, use the DATA DIRECTORY clause of the CREATE TABLE statement instead of symbolic links, as explained in Section 17.6.1.2, “Creating Tables ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-13.html
It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. (Bug #28246270, Bug #91421) A new connection property, sslMode, has been introduced to replace the connection properties useSSL, requireSSL, and ... Version ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-asp-roles.html
This requires that the developer creates database tables to store user information, along with code to gather and process this data. Create a new MySQL database using the MySQL Command-Line Client program (mysql), or other suitable tool. It does not ... Many websites feature the facility for the user to create a user ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-asp-roles.html
This requires that the developer creates database tables to store user information, along with code to gather and process this data. Create a new MySQL database using the MySQL Command-Line Client program (mysql), or other suitable tool. It does not ... Many websites feature the facility for the user to create a user ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Although you can select INFORMATION_SCHEMA as the default database ...Other terms that are sometimes used for this information are data dictionary and system ...