![]() ![]() 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”). Mapping database names to database directory names (see With the database to use the encoding implemented in MySQL 5.1 for NAME clause updates the name of the directory associated 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.6.5, “ SHOW COLLATION Syntax”, for more information. See Section 12.4.6.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. 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.5. ![]() 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.22. CREATE PROCEDURE andĬREATE FUNCTION Syntax 12.1.13. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |