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/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
When using MySQL as a document store, to create documents describing products you do not need to know and define all possible attributes of any products before storing them and operating with them. See X DevAPI User Guide for in-depth tutorials on ... This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-views.html
You may also find the MySQL User Forums to be helpful. Is there a discussion forum for MySQL Views? See the MySQL User Forums. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop ...What happens to a view if an underlying table is dropped or renamed? ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
The VALUE column is empty if there is no user-defined stopword table. use_stopword: Indicates whether a stopword table is used, which is defined when the FULLTEXT index is created. The INNODB_FT_CONFIG table provides metadata about the FULLTEXT ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-basics.html
For more information about the files and directories created by local checkpoints and global checkpoints, see NDB Cluster Data Node File System Directory. Because it is ubiquitous, most users employ TCP/IP over Ethernet for NDB Cluster. NDBCLUSTER ...
https://dev.mysql.com/doc/refman/5.7/en/solaris-installation.html
If you would like MySQL to start automatically, you can copy support-files/mysql.server to /etc/init.d and create a symbolic link to it named /etc/rc3.d/S99mysql.server. If you enable setuid() core files for the current user, they are generated ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. Additional Resources You may find the Stored Procedures User Forum of use when working with stored ...A ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
In this case, you must use ALTER TABLE to increase the MAX_ROWS and AVG_ROW_LENGTH table option values: ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy; If you do not know the current table option values, use SHOW CREATE TABLE. On Unix, make ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
An initial start erases any files created for recovery purposes by earlier instances of ndbd. An --initial start is to be used only when starting the ndbd process under very special circumstances; this is because this option causes all files to be ... The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/5.7/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.