This table that lists every MySQL Server option or variable, what version it was introduced or deprecated in, whether it’s dynamic or not, whether variables have session/global/both scope, and links to the version-specific documentation for that variable. Name Intr Depr
I want to populate automaticaly another table when new data is inserted: For table “source_table” define a after insert trigger
CREATE TRIGGER `source_table_AINS` AFTER INSERT ON `source_table` FOR EACH ROW
-- Edit trigger body code below this line. Do not edit lines above this one
insert into dest_table set source_id=NEW.id;
The “NEW” alias contains all inserted fields into table “source_table”; After “insert” event on table “source_table”, we set the
MySQL Utilities This is a brief overview of the MySQL command-line utilities. See their respective manual pages for further details and examples: mysqlauditadmin Monitor the audit log. Copy, rotate, and configure the audit log mysqlauditgrep Search the audit log. Output results to
On MySQL master, “RESET MASTER” command, deletes all binary log files listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. This statement is intended to be used only
Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves). Replication is asynchronous – slaves need not be connected permanently to receive updates from the master. This means
Apache webserver can be configured to save access logs into database via Apache Module mod_log_config. This module provides for flexible logging of client requests. Logs are written in a customizable format, and may be written directly to a file, or to
This option prevents MySQL from performing update operations unless a key constraint in the WHERE clause and / or a LIMIT clause are provided.
mysql --i-am-a-dummy -uroot test
For beginners, a useful startup option is –safe-updates (or –i-am-a-dummy, which has the same effect).