Search results
This is the MySQL™ Reference Manual. It documents MySQL 5.0 through 5.0.92. This manual is for MySQL Enterprise Server, our commercial offering, and for MySQL Community Server. Sections that do not apply for MySQL Enterprise Server users are marked: This section does not apply to MySQL Enterprise Server users.
- Stored Programs and View
This table is created during the MySQL 5.0 installation...
- Connectors & APIs
The C API provides low-level access to the MySQL protocol...
- 19 Information_Schema Tables
However, because SHOW is popular and because it might be...
- Server Administration
Enable old-style user limits. (Before MySQL 5.0.3, account...
- Information_Schema Index
TABLES Chapter 19, INFORMATION_SCHEMA Tables Section 13.2.3,...
- 21. Extending MySQL
Prior to MySQL 5.0.67, or if the value of plugin_dir is...
- 1. General Information
This is the Reference Manual for the MySQL Database System,...
- 6. Backup and Recovery
mysql> source dump.sql. If the file is a single-database...
- Stored Programs and View
UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = value assignment_list: assignment [, assignment] ...
For example, after upgrading from MySQL 9.0 to MySQL 9.1, you may notice that tables no longer have .frm files. If this step fails, the server reverts all changes to the data directory. In this case, you should remove all redo log files, start your MySQL 9.0 server on the same data directory, and fix the cause of any errors.
As Administrator, run mysql_upgrade to check your tables, attempt to repair them if necessary, and update your grant tables if they have changed so that you can take advantage of any new capabilities. See Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”.
You must edit this template (menu File > Open Template > MySQL (my.cnf) > 5.7.30) to modify the MySQL configuration. Manually adding “my.cnf” files to other locations is not recommended. Every configuration aspect can be handled with the MySQL template.
MySQL :: MySQL Community Downloads
This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.34. Differences between minor versions of MySQL 5.7 are noted in the present text with reference to release numbers (5.7. x). For license information, see the Legal Notices.
