May not use stored routines or user-defined functions in suchĮxpressions, nor may you use any table references however, you Involving built-in MySQL functions and user variables to obtain The ON SCHEDULE clause may use expressions Options which are omitted retain their existing values. It is necessary to include only those options in anĬorrespond to characteristics that you actually wish to change Mytable it also changes the schedule for theĮvent such that it executes once, one day after this This example changes the SQL statement executedīy myevent to one that deletes all records from It is possible to change multiple characteristics of an event in a STARTS CURRENT_TIMESTAMP + INTERVAL 4 HOUR Immediately to once every twelve hours, starting four hours from Myevent from once every six hours starting The following statement changes the schedule for UPDATE myschema.mytable SET mycol = mycol + 1 In each of the following examples, assume that the event named > EVERY '2:3' DAY_HOUR ERROR 1517 (HY000): Unknown event 'no_such_event' (In MySQL 5.1.11 and earlier, an event could be altered only by Statement, that user becomes the definer for the affected event. Support for the DEFINER clause was added inīeginning with MySQL 5.1.12, this statement requires the Section 12.1.11, “ CREATE EVENT Syntax”.) Without the need to drop and recreate it. To change one or more of the characteristics of an existing event UPGRADE DATA DIRECTORY NAME in this case toĮxplicitly tell the server to re-encode the database directoryĪLTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME Īfter executing this statement, you can refer to the database as #mysql50#a-b-c, and you must refer to the name When a MySQL installation is upgraded to MySQL 5.1 or later fromĪn older version,the server displays a name such as Same database name is encoded as produce a file system-neutral directory name. It is intended to update a database directory name to theĬurrent encoding format if the name contains specialįor example,if a database in MySQL 5.0 has a name ofĭirectory is also named a-b-c, which is not It is intended when upgrading MySQL to 5.1 or later from older Section 8.2.3, “Mapping of Identifiers to File Names”). Name of the directory associated with the database to use theĮncoding implemented in MySQL 5.1 for mapping database names to ![]() The syntax that includes the UPGRADE DATA DIRECTORY ![]() The database name can be omitted from the first syntax, in whichĬase the statement applies to the default database. Section 12.4.5.5, “ SHOW COLLATION Syntax”, for more information. See Section 12.4.5.4, “ SHOW CHARACTER SET Syntax”, and You can see what character sets and collations are available Section 9.1, “Character Set Support”,ĭiscusses character set and collation names. ![]() The COLLATE clauseĬhanges the default database collation. The CHARACTER SET clause changes the defaultĭatabase character set. TheseĬharacteristics are stored in the db.opt file ALTER DATABASE Syntax ALTER Ĭhange the overall characteristics of a database. CREATE PROCEDURE andĭROP FUNCTION Syntax 12.1.27. This chapter describes the syntax for the SQL statements supportedġ2.1.1. Automatic Prepared Statement Repreparation 12.7. SQL Syntax for Prepared Statements 12.6.1. ![]() SQL Statements for Controlling Slave Servers 12.6. SQL Statements for Controlling Master Servers 12.5.2. Plugin and User-Defined Function Statements 12.4.4. Database Administration Statements 12.4.1. Statements That Cause an Implicit Commit 12.3.4. Statements That Cannot Be Rolled Back 12.3.3. MySQL Transactional and Locking Statements 12.3.1. DROP PROCEDURE andĭROP FUNCTION Syntax 12.1.27. CREATE PROCEDURE andĬREATE FUNCTION Syntax 12.1.16.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |