12.21.3 Window Function Frame Specification ............................................................... 2428 12.21.4 Named Windows .............................................................................................. 2432 12.21.5 Window Function Restrictions ........................................................................... 2433 12.22 Performance Schema Functions .................................................................................. 2433 12.23 Internal Functions ........................................................................................................ 2436 12.24 Miscellaneous Functions .............................................................................................. 2438 12.25 Precision Math ............................................................................................................ 2454 12.25.1 Types of Numeric Values .................................................................................. 2454 12.25.2 DECIMAL Data Type Characteristics ................................................................. 2455 12.25.3 Expression Handling ......................................................................................... 2456 12.25.4 Rounding Behavior ........................................................................................... 2458 12.25.5 Precision Math Examples .................................................................................. 2459 13 SQL Statements ...................................................................................................................... 2463 13.1 Data Definition Statements ............................................................................................ 2464 13.1.1 Atomic Data Definition Statement Support ........................................................... 2464 13.1.2 ALTER DATABASE Statement ............................................................................ 2470 13.1.3 ALTER EVENT Statement .................................................................................. 2475 13.1.4 ALTER FUNCTION Statement ............................................................................ 2477 13.1.5 ALTER INSTANCE Statement ............................................................................ 2477 13.1.6 ALTER LOGFILE GROUP Statement .................................................................. 2479 13.1.7 ALTER PROCEDURE Statement ........................................................................ 2481 13.1.8 ALTER SERVER Statement ................................................................................ 2481 13.1.9 ALTER TABLE Statement ................................................................................... 2481 13.1.10 ALTER TABLESPACE Statement ...................................................................... 2505 13.1.11 ALTER VIEW Statement ................................................................................... 2507 13.1.12 CREATE DATABASE Statement ....................................................................... 2507 13.1.13 CREATE EVENT Statement .............................................................................. 2508 13.1.14 CREATE FUNCTION Statement ........................................................................ 2513 13.1.15 CREATE INDEX Statement .............................................................................. 2513 13.1.16 CREATE LOGFILE GROUP Statement ............................................................. 2528 13.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements ........................... 2530 13.1.18 CREATE SERVER Statement ........................................................................... 2535 13.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement ....................................... 2536 13.1.20 CREATE TABLE Statement .............................................................................. 2541 13.1.21 CREATE TABLESPACE Statement ................................................................... 2597 13.1.22 CREATE TRIGGER Statement .......................................................................... 2604 13.1.23 CREATE VIEW Statement ................................................................................ 2606 13.1.24 DROP DATABASE Statement ........................................................................... 2610 13.1.25 DROP EVENT Statement ................................................................................. 2611 13.1.26 DROP FUNCTION Statement ........................................................................... 2611 13.1.27 DROP INDEX Statement .................................................................................. 2612 13.1.28 DROP LOGFILE GROUP Statement ................................................................. 2612 13.1.29 DROP PROCEDURE and DROP FUNCTION Statements ................................... 2613 13.1.30 DROP SERVER Statement ............................................................................... 2613 13.1.31 DROP SPATIAL REFERENCE SYSTEM Statement ........................................... 2613 13.1.32 DROP TABLE Statement .................................................................................. 2614 13.1.33 DROP TABLESPACE Statement ....................................................................... 2615 13.1.34 DROP TRIGGER Statement ............................................................................. 2616 13.1.35 DROP VIEW Statement .................................................................................... 2616 13.1.36 RENAME TABLE Statement ............................................................................. 2617 13.1.37 TRUNCATE TABLE Statement .......................................................................... 2619 13.2 Data Manipulation Statements ....................................................................................... 2620 13.2.1 CALL Statement ................................................................................................. 2620 13.2.2 DELETE Statement ............................................................................................ 2621 xiv MySQL 8.0 Reference Manual