Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
We could calculate tomorrow by calling a database function, but for clarity we do it in Python using the datetime module. Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-channel-filter-rules.html
However, you can add multiple filter rules and the result is the logical addition of all the rules. For example, if you create a filter rule with type, REPLICATE_DO_DB, and filter value, mysql1, and another filter rule, with type, REPLICATE_DO_DB, ... Channel Filter Rules for Inbound Replication 8.5.1 Channel Filter Rules for Inbound Replication Each filter rule can contain only one filter type and ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database contents. This type of backup is suitable for large, important databases that need to be recovered quickly when problems ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
How table and database names are stored on disk and used in MySQL is affected by the lower_case_table_names system variable. The main disadvantage with this is that when you use SHOW TABLES or SHOW DATABASES, you do not see the names in their ... In ...This means such names are not case-sensitive in Windows, but are case-sensitive in most varieties of ...
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
The rows in these tables for a given account indicate the account privileges that apply on a global basis no matter what the default database is. For example, if the user table grants you the DELETE privilege, you can delete rows from any table in ... After the server accepts a connection, it enters Stage 2 of access ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
By default, tables are created in the default database, using the InnoDB storage engine. An error occurs if the table exists, if there is no default database, or if the database does not exist. This works regardless of whether there is a default ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
This function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default (current) database name as a ...
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
There is a new macro, HA_VARCHAR_PACKLENGTH(field_length), that can be used on field->length in write_row / read_row to check how many length bytes are used. If you run MySQL 5.0 with the --new option, MySQL will show old VARCHAR columns as 'CHAR' ... Next I'll describe the physical attributes of each column in a ...
https://dev.mysql.com/doc/internals/en/load-data-infile-events.html
The events indicate what options are present in the statement and how to process the data file. LOAD DATA INFILE is not written to the binary log like other statements. It is written as one or more events in a packed format, not as a cleartext ...
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-context.html
As with the methods previously shown for persisting instances in and removing them from the database, update() exists in three variations, which allow you to use the instance as an object, an object constructor with keys, or by tableName and keys. A ...It contains functions that are executed immediately if called from a session, or when the batch is ...