Selecting SQL Modes The MySQL server can operate in different SQL modes, and can apply these modes differentially for different clients. This capability enables each application to tailor the server's operating mode to its own requirements. SQL modes control aspects of server operation such as w...
Setting Environment Variables Environment variables can be set at the command prompt to affect the current invocation of your command processor, or set permanently to affect future invocations. To set a variable permanently, you can set it i...
Specifying Program Options There are several ways to specify options for MySQL programs: • List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. • List the options in an option file that the program reads w...
SQL Syntax for Online DDL Typically, you do not need to do anything special to enable online DDL when using the ALTER TABLE statement for InnoDB tables. See Table 5.9, “Summary of Online Status for DDL Operations” for the kinds of DDL operations ...
Statement Probes The individual statement probes are provided to give specific information about different statement types. For the start probes the string of the query is provided as a the only argument. Depending on the statement type, the information provided by the corresponding done probe wi...
Statements and Functions: • Full operator and function support in the SELECT list and WHERE clause of queries. For example: mysql SELECT CONCAT(first_name, ' ', last_name) - FROM citizen - WHERE income/dependents 1 AND age 30; • Full support...
Testing The MySQL Installation You can test whether the MySQL server is working by executing any of the following commands: C:\ "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlshow" C:\ "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqlshow" -u root mysql C:\ "C:\Progr...
The Main Features of MySQL This section describes some of the important characteristics of the MySQL Database Software. See also Section 1.5, “MySQL Development History”. In most respects, the roadmap applies to all versions of MySQL. For information about features as they are introduced into MyS...
The MySQL Database Server is very fast, reliable, scalable, and easy to use. If that is what you are looking for, you should give it a try. MySQL Server can run comfortably on a desktop or laptop, alongside your other applications, web servers, an...
The Row Holding the Maximum of a Certain Column Task: Find the number, dealer, and price of the most expensive article. This is easily done with a subquery: SELECT article, dealer, price FROM shop WHERE price=(SELECT MAX(price) FROM shop); ++++ | article | dealer | price | ++++ | 0004 | D |...
