![](https://csdnimg.cn/release/download_crawler_static/5266973/bg10.jpg)
table of contents
xxii
i
The Top Ten Topics (we didn’t cover)
leftovers
Even after all that, there’s a bit more. There are just a few
more things we think you need to know. We wouldn’t feel right about ignoring
them, even though they only need a brief mention. So before you put the book
down, take a read through these short but important SQL tidbits.
Besides, once you’re done here, all that’s left is another appendix... and the
index... and maybe some ads... and then you’re really done. We promise!
#1. Get a GUI for your RDBMS 526
#2. Reserved Words and Special Characters 528
#3. ALL, ANY, and SOME 530
#4. More on Data Types 532
#5. Temporary tables 534
#6. Cast your data 535
#7. Who are you? What time is it? 536
#8. Useful numeric functions 537
#9. Indexing to speed things up 539
#10. 2-minute PHP/MySQL 540
A
ABSOLUTE ACTION ADD ADMIN AFTER AGGREGATE ALIAS ALL ALLOCATE ALTER AND ANY ARE ARRAY AS
ASC ASSERTION AT AUTHORIZATION
B
BEFORE BEGIN BINARY BIT BLOB BOOLEAN BOTH BREADTH BY
C
CALL CASCADE CASCADED CASE CAST CATALOG CHAR CHARACTER CHECK CLASS CLOB CLOSE COLLATE
COLLATION COLUMN COMMIT COMPLETION CONNECT CONNECTION CONSTRAINT CONSTRAINTS
CONSTRUCTOR CONTINUE CORRESPONDING CREATE CROSS CUBE CURRENT CURRENT_DATE
CURRENT_PATH CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CYCLE
D
DATA DATE DAY DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DEPTH
DEREF DESC DESCRIBE DESCRIPTOR DESTROY DESTRUCTOR DETERMINISTIC DICTIONARY DIAGNOSTICS
DISCONNECT DISTINCT DOMAIN DOUBLE DROP DYNAMIC
E
EACH ELSE END END_EXEC EQUALS ESCAPE EVERY EXCEPT EXCEPTION EXEC EXECUTE EXTERNAL
F
FALSE FETCH FIRST FLOAT FOR FOREIGN FOUND FROM FREE FULL FUNCTION
G
GENERAL GET GLOBAL GO GOTO GRANT GROUP GROUPING
H
HAVING HOST HOUR
I
IDENTITY IGNORE IMMEDIATE IN INDICATOR INITIALIZE INITIALLY INNER INOUT INPUT INSERT
INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION ITERATE
J
JOIN
K
KEY
L
LANGUAGE LARGE LAST LATERAL LEADING LEFT LESS LEVEL LIKE LIMIT LOCAL LOCALTIME
LOCALTIMESTAMP LOCATOR
M
MAP MATCH MINUTE MODIFIES MODIFY MODULE MONTH
N
NAMES NATIONAL NATURAL NCHAR NCLOB NEW NEXT NO NONE NOT NULL NUMERIC
O
OBJECT OF OFF OLD ON ONLY OPEN OPERATION OPTION OR ORDER ORDINALITY OUT OUTER OUTPUT
P
PAD PARAMETER PARAMETERS PARTIAL PATH POSTFIX PRECISION PREFIX PREORDER PREPARE
PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC
Q
R
READ READS REAL RECURSIVE REF REFERENCES REFERENCING RELATIVE RESTRICT RESULT RETURN
RETURNS REVOKE RIGHT ROLE ROLLBACK ROLLUP ROUTINE ROW ROWS
S
SAVEPOINT SCHEMA SCROLL SCOPE SEARCH SECOND SECTION SELECT SEQUENCE SESSION
SESSION_USER SET SETS SIZE SMALLINT SOME SPACE SPECIFIC SPECIFICTYPE SQL SQLEXCEPTION
SQLSTATE SQLWARNING START STATE STATEMENT STATIC STRUCTURE SYSTEM_USER
T
TABLE TEMPORARY TERMINATE THAN THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO
TRAILING TRANSACTION TRANSLATION TREAT TRIGGER TRUE
U
UNDER UNION UNIQUE UNKNOWN UNNEST UPDATE USAGE USER USING
V
VALUE VALUES VARCHAR VARIABLE VARYING VIEW
W
WHEN WHENEVER WHERE WITH WITHOUT WORK WRITE
X
Y
YEAR
Z
ZONE