PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
One way this might occur is that there is no account listed in the grant tables for davida. However, this is faster than running the query again without LIMIT, because the result set need not be sent to the client. An example is a Web script that ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
The files you need for Perl support can be obtained from the CPAN (Comprehensive Perl Archive Network) at http://search.cpan.org. It is also possible to download the module distributions in the form of compressed tar archives and build the modules ... MySQL Perl support requires that you have installed MySQL client programming support (libraries and header ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. This includes any ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). As soon as this lock has been acquired, the binary log coordinates are read and the lock is released. While the server ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
In this Manual, we use dashes in option names, except where underscores are significant. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as --password. This ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-linux-quick.html
This is an example of the subrepository's default entry in the file (the baseurl entry in your file might look different, depending on your Linux distribution): [mysql-tools-preview] name=MySQL Tools Preview ...To do so, you need to remove your old ... Note Installation packages for MySQL Shell are available only for a limited number of Linux distributions, and only for 64-bit ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command Line”. To start multiple servers this way, you can specify the appropriate options on the ...It is more convenient to place the options in an option file, but it is necessary to make sure that each server gets its own set of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
The numeric values specified for this option correspond to isolation levels such as REPEATABLE READ. This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
This issue can occur if MySQL is configured to read from or write to a non-default directory or file. In this case, a “denial” message is logged to /var/log/audit/audit.log: $> grep "denied" /var/log/audit/audit.log type=AVC ... Troubleshooting ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A consequence of this is that SET member values should not themselves contain commas. For more information on this limit, see Limits Imposed by .frm File Structure. For example, you can retrieve numeric values from a SET column like this: mysql> ...