MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 131 to 140 of 150 total results

https://dev.mysql.com/doc/refman/5.7/en/selecting-all.html

For example, you may happen to think that the birth date for Bowser does not seem quite right. Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the ...

3.3.4.3 Selecting Particular Columns

https://dev.mysql.com/doc/refman/5.7/en/selecting-columns.html

If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.

3.3.4.2 Selecting Particular Rows

https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html

As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...

5.6 MySQL Server Loadable Functions

https://dev.mysql.com/doc/refman/5.7/en/server-loadable-functions.html

See Section 5.5.4, “The Rewriter Query Rewrite Plugin” Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports loadable functions, ...

5.1.6 Server Command Options

https://dev.mysql.com/doc/refman/5.7/en/server-options.html

--sql-mode=value[,value[,value...]] Command-Line Format --sql-mode=name System Variable sql_mode Scope Global, Session Dynamic Yes Type Set Default Value ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...

5.5 MySQL Server Plugins

https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html

Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at ...

13.7.5.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html

row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE ... SHOW CREATE ...

13.7.5.28 SHOW PROCEDURE STATUS Statement

https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html

It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. A ...

13.7.5.38 SHOW TRIGGERS Statement

https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html

row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...

23.8 Restrictions on Stored Programs

https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html

If a trigger uses a table and the table has changed since the trigger was loaded into the cache, the trigger operates using the outdated metadata. Consequently, stored functions that update the same underlying tables do not execute in parallel. Some ...

Displaying 131 to 140 of 150 total results