Using Options on the Command Line Program options specified on the command line follow these rules: • Options are given after the command name. • An option argument begins with one dash or two dashes, depending on whether it is a short form or ...
Using Options to Set Program Variables Many MySQL programs have internal variables that can be set at runtime using the SET statement. See Section 13.7.4, “SET Syntax”, and Section 5.1.5, “Using System Variables”. Most of these program variables also can be set at server startup by using the same...
Using SMF to manage your MySQL installation Once installed, you can start and stop your MySQL server using the installed SMF configuration. The service name is mysql, or if you have multiple versions installed, you should use the full version name, for example mysql:version_56. To start and enabl...
Verifying Package Integrity Using MD5 Checksums or GnuPG After you have downloaded the MySQL package that suits your needs and before you attempt to install it, you should make sure that it is intact and has not been tampered with. There are three means of integrity checking: • MD5 checksums • ...
Verifying the MD5 Checksum After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages. Each package has an individual checksum that you can verify against the package that you downloaded. The correct MD5 checksum is l...
Workarounds for Reliability with Non-Transactional Tables But how do you use the features of MySQL Server to maintain integrity even with the nontransactional MyISAM tables, and how do these features compare with the transactional storage engines? • If your applications are written in a way that ...
Working with NULL Values The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. To test for NULL, use the IS NULL [1188] and IS NOT NULL [1188] operators, as shown here: mysql SELECT ...
Upgrading or Downgrading MySQL This section describes the steps to upgrade or downgrade a MySQL installation. Upgrading is a common procedure, as you pick up bug fixes within the same MySQL re...
Invoking MySQL Programs To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or other arguments needed to instruct the program what you want it to do. The following commands show some sample program invocation...
Contributors to MySQL Although Oracle Corporation and/or its affiliates own all copyrights in the MySQL server and the MySQL manual, we wish to recognize those who have made contributions of one kind or another to the MySQL distribution. Contribu...
