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/language-structure.html
This chapter discusses the rules for writing the following elements of SQL statements when using MySQL: Literal values such as strings and numbers Identifiers such as database, table, and column names Keywords and reserved words User-defined and ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-example.html
These two example programs should work without any changes on a Linux or FreeBSD system. For other operating systems, minor changes are needed, mostly with file paths. These examples are designed to give enough details for you to understand the ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld.html
Table 27.2 MySQL Embedded Server Library Functions Function When to Call mysql_library_init() Call it before any other MySQL function is called, preferably early in the main() function. The embedded MySQL server library makes it possible to run a ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation.html
Linux supports a number of different solutions for installing MySQL. You can also use My Oracle Support for the MySQL Enterprise Edition. Documentation Oracle Unbreakable Linux Network Use ULN channels Documentation As an alternative, you can use ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
A local variable should not have the same name as a table column. Consequently, when the procedure sp1()is called, the newname variable returns the value 'bob' regardless of the value of the table1.xname column. The scope of a local variable is the ...
https://dev.mysql.com/doc/refman/5.7/en/logical-operators.html
Table 12.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...
https://dev.mysql.com/doc/refman/5.7/en/midpoint-insertion.html
When an index block is read from a table into the key cache, it is placed at the end of the warm sublist. By default, the key cache management system uses a simple LRU strategy for choosing key cache blocks to be evicted, but it also supports a ...
https://dev.mysql.com/doc/refman/5.7/en/monitoring-performance-schema.html
You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.
https://dev.mysql.com/doc/refman/5.7/en/multiple-data-directories.html
Even when the preceding precautions are observed, this kind of setup works only with MyISAM and MERGE tables, and not with any of the other storage engines. Each MySQL Instance on a machine should have its own data directory. There are different ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
Use this procedure: Make sure that each data directory exists, including its own copy of the mysql database that contains the grant tables. The procedure for starting a single MySQL server manually from the command line is described in Section ...