Stored routine, variables with character data types use theĭatabase defaults if the character set or collation are not If you change the default character set or collation for aĭatabase, stored routines that use the database defaults must beĭropped and recreated so that they use the new defaults. Section 13.7.5.5, “SHOW COLLATION Syntax”, for more information. See Section 13.7.5.4, “SHOW CHARACTER SET Syntax”, and You can see what character sets and collations are available Section 10.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. The database name can be omitted from the first syntax, in whichĬase the statement applies to the default database. TheseĬharacteristics are stored in the db.opt file This chapter describes the syntax for theĬhange the overall characteristics of a database. END Compound-Statement Syntax 13.6.2 Statement Label Syntax 13.6.3 DECLARE Syntax 13.6.4 Variables in Stored Programs 13.6.5 Flow Control Statements 13.6.6 Cursors 13.6.7 Condition Handling 13.7 Database Administration Statements 13.7.1 Account Management Statements 13.7.2 Table Maintenance Statements 13.7.3 Plugin and User-Defined Function Statements 13.7.4 SET Syntax 13.7.5 SHOW Syntax 13.7.6 Other Administrative Statements 13.8 MySQL Utility Statements 13.8.1 DESCRIBE Syntax 13.8.2 EXPLAIN Syntax 13.8.3 HELP Syntax 13.8.4 USE Syntax Table of Contents 13.1 Data Definition Statements 13.1.1 ALTER DATABASE Syntax 13.1.2 ALTER EVENT Syntax 13.1.3 ALTER LOGFILE GROUP Syntax 13.1.4 ALTER FUNCTION Syntax 13.1.5 ALTER PROCEDURE Syntax 13.1.6 ALTER SERVER Syntax 13.1.7 ALTER TABLE Syntax 13.1.8 ALTER TABLESPACE Syntax 13.1.9 ALTER VIEW Syntax 13.1.10 CREATE DATABASE Syntax 13.1.11 CREATE EVENT Syntax 13.1.12 CREATE FUNCTION Syntax 13.1.13 CREATE INDEX Syntax 13.1.14 CREATE LOGFILE GROUP Syntax 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax 13.1.16 CREATE SERVER Syntax 13.1.17 CREATE TABLE Syntax 13.1.18 CREATE TABLESPACE Syntax 13.1.19 CREATE TRIGGER Syntax 13.1.20 CREATE VIEW Syntax 13.1.21 DROP DATABASE Syntax 13.1.22 DROP EVENT Syntax 13.1.23 DROP FUNCTION Syntax 13.1.24 DROP INDEX Syntax 13.1.25 DROP LOGFILE GROUP Syntax 13.1.26 DROP PROCEDURE and DROP FUNCTION Syntax 13.1.27 DROP SERVER Syntax 13.1.28 DROP TABLE Syntax 13.1.29 DROP TABLESPACE Syntax 13.1.30 DROP TRIGGER Syntax 13.1.31 DROP VIEW Syntax 13.1.32 RENAME TABLE Syntax 13.1.33 TRUNCATE TABLE Syntax 13.2 Data Manipulation Statements 13.2.1 CALL Syntax 13.2.2 DELETE Syntax 13.2.3 DO Syntax 13.2.4 HANDLER Syntax 13.2.5 INSERT Syntax 13.2.6 LOAD DATA INFILE Syntax 13.2.7 LOAD XML Syntax 13.2.8 REPLACE Syntax 13.2.9 SELECT Syntax 13.2.10 Subquery Syntax 13.2.11 UPDATE Syntax 13.3 MySQL Transactional and Locking Statements 13.3.1 START TRANSACTION, COMMIT, and ROLLBACK Syntax 13.3.2 Statements That Cannot Be Rolled Back 13.3.3 Statements That Cause an Implicit Commit 13.3.4 SAVEPOINT, ROLLBACK TO SAVEPOINT, and RELEASE SAVEPOINT Syntax 13.3.5 LOCK TABLES and UNLOCK TABLES Syntax 13.3.6 SET TRANSACTION Syntax 13.3.7 XA Transactions 13.4 Replication Statements 13.4.1 SQL Statements for Controlling Master Servers 13.4.2 SQL Statements for Controlling Slave Servers 13.5 SQL Syntax for Prepared Statements 13.5.1 PREPARE Syntax 13.5.2 EXECUTE Syntax 13.5.3 DEALLOCATE PREPARE Syntax 13.5.4 Automatic Prepared Statement Repreparation 13.6 MySQL Compound-Statement Syntax 13.6.1 BEGIN.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |