PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
IF NOT EXISTS has the same meaning for CREATE EVENT as for CREATE TABLE: If an event named event_name already exists in the same schema, no action is taken, and no error results. row *************************** Level: Note Code: 1588 Message: Event ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Make sure that any error handlers in your application also ROLLBACK incomplete changes or COMMIT completed changes. Handling Deadlocks You might see warning messages referring to “deadlocks” in the MySQL error log, or the output of SHOW ENGINE ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
The strings you specify as input values are automatically encoded as numbers. The index value of the empty string error value is 0. If strict SQL mode is enabled, attempts to insert invalid ENUM values result in an error. Duplicate values in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
Your application code can ensure referential integrity throughout this sequence of operations. For another example, consider an integer counter field in a table CHILD_CODES, used to assign a unique identifier to each child added to table CHILD. For ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
Possible causes include but are not limited to file system errors. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbmtd.html
Trace files are generated by critical errors in ndbmtd processes in a somewhat different fashion from how these are generated by ndbd failures. In the event of a critical error, ndbmtd generates trace files describing what happened just prior to the ... ndbmtd is a multithreaded version of ndbd, the process that is used to handle all the data in tables using the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
If the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. If the query returns multiple rows, error 1172 occurs (Result consisted of more than one row). An example of such a statement is ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. This means that, if the index requires unique values, duplicate-key errors occur for values ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...