  |
|
||
|
||
|
Here are definitions not included in the MySQL Card and Chart. (Do you think they should be? Would you remove something else? More pages?) These are the answers to all the little gray reference◊ symbols in print.
This page:
condition◊ as in: CREATE PROCEDURE … DELCARE … CONDITION FOR condition◊ … ; (manual's condition_value for Conditions)
distributed-transaction-commands◊ as in statement: XA distributed-transaction-commands◊;
encryption◊ used in GRANT … REQUIRE encryption◊
error_number◊ (4 digit) and
error_state◊ (5 character) used in handling error conditions
h-before◊ (manual's handler_type) and
h-after◊ (manual's condition_value for Handlers) used in CREATE PROCEDURE … DELCARE h-before◊ HANDLER FOR h-after◊ … ;
named-characters◊ used in ♦sRegularExpression, for REGEXP or RLIKE comparison
partition-definition◊ and
partition-command◊ used in ♦tops and CREATE TABLE and ALTER TABLE
reserved-words◊ avoid as identifiers, or backtick-quote
time◊ used in ♦event-definition
See the expanded DECLARE clause below.
♦distributed-transaction-commands
Here are the distributed transaction commands, part of the XA statement.
Here are the encryptions that can be required for user connections. They are used in the GRANT statement:
If you specify more than one of the last three options you may separate them with AND.
♦error_number and
♦error_state
See the MySQL Manual for Error Codes (Appendix C for the 5.1 manual). error_state◊ is a 5-character code for a broad class of conditions, e.g. 'HY000'. error_number◊ is a 4-digit number for a specific error, e.g. 1022 for duplicate key. It is called an sqlstate_value in the manual.
These are used only on this page, not in print.
A handler is SQL that responds to a MySQL error condition.
It gets declared at the beginning of a procedure or function in its CREATE statement.
Here are the parts of the handler declaration that aren't defined on the printed reference.
Here is the compact DECLARE clause from the the CREATE FUNCTION/PROCEDURE statement from the printed reference.
(Note the erroneous dotted line around h-after◊ — it should be comma-separated.)
Here's an expanded DECLARE clause. This would be in the printed reference if there were room:
Here are all special named characters (manual calls these "collating elements") for MySQL Regular Expressions. An appendix of the MySQL manual says they are listed in the source file regexp/cname.h
Example: SELECT * FROM t WHERE c REGEXP '[[.CR.]][[.LF.]]' (CR-LF pair)
[.NUL.]
[.SOH.]
[.STX.]
[.ETX.]
[.EOT.]
[.ENQ.]
[.ACK.]
[.BEL.]
[.alert.]
[.BS.]
[.backspace.] [.\b.]
[.HT.]
[.tab.] [.\t.]
[.LF.]
[.newline.] [.\n.]
[.VT.]
[.vertical-tab.]
[.FF.]
[.form-feed.]
[.CR.]
[.carriage-return.] [.\r.]
[.SO.]
[.SI.]
[.DLE.]
[.DC1.]
[.DC2.]
[.DC3.]
[.DC4.]
[.NAK.]
[.SYN.]
[.ETB.]
[.CAN.]
[.EM.]
[.SUB.]
[.ESC.]
[.IS4.]
[.FS.]
[.IS3.]
[.GS.]
[.IS2.]
[.RS.]
[.IS1.]
[.US.]
[.space.] [. .]
[.exclamation-mark.] [.!.]
[.quotation-mark.] [.\".]
[.number-sign.] [.#.]
[.dollar-sign.] [.$.]
[.percent-sign.] [.%.]
[.ampersand.] [.&.]
[.apostrophe.] [.\'.]
[.left-parenthesis.] [.(.]
[.right-parenthesis.] [.).]
[.asterisk.] [.*.]
[.plus-sign.] [.+.]
[.comma.] [.,.]
[.hyphen.] [.-.]
[.hyphen-minus.] [.-.]
[.period.] [...]
[.full-stop.] [...]
[.slash.] [./.]
[.solidus.] [./.]
[.zero.] [.0.]
[.one.] [.1.]
[.two.] [.2.]
[.three.] [.3.]
[.four.] [.4.]
[.five.] [.5.]
[.six.] [.6.]
[.seven.] [.7.]
[.eight.] [.8.]
[.nine.] [.9.]
[.colon.] [.:.]
[.semicolon.] [.;.]
[.less-than-sign.] [.<.]
[.equals-sign.] [.=.]
[.greater-than-sign.] [.>.]
[.question-mark.] [.?.]
[.commercial-at.] [.@.]
[.left-square-bracket.] [.[.]
[.backslash.] [.\\.]
[.reverse-solidus.] [.\\.]
[.right-square-bracket.] [.].]
[.circumflex.] [.^.]
[.circumflex-accent.] [.^.]
[.underscore.] [._.]
[.low-line.] [._.]
[.grave-accent.] [.`.]
[.left-brace.] [.{.]
[.left-curly-bracket.] [.{.]
[.vertical-line.] [.|.]
[.right-brace.] [.}.]
[.right-curly-bracket.] [.}.]
[.tilde.] [.~.]
[.DEL.]
♦partition-definition and
♦partition-command
ACCESSIBLE ADD ALL ALTER ANALYZE AND AS ASC ASENSITIVE BEFORE BETWEEN BIGINT BINARY BLOB BOTH BY CALL CASCADE CASE CHANGE CHAR CHARACTER CHECK COLLATE COLUMN CONDITION CONNECTION CONSTRAINT CONTINUE CONVERT CREATE CROSS CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR |
DATABASE DATABASES DAY_HOUR DAY_MICROSECOND DAY_MINUTE DAY_SECOND DEC DECIMAL DECLARE DEFAULT DELAYED DELETE DESC DESCRIBE DETERMINISTIC DISTINCT DISTINCTROW DIV DOUBLE DROP DUAL EACH ELSE ELSEIF ENCLOSED ESCAPED EXISTS EXIT EXPLAIN FALSE FETCH FLOAT FLOAT4 FLOAT8 FOR FORCE FOREIGN FROM FULLTEXT |
GRANT GROUP HAVING HIGH_PRIORITY HOUR_MICROSECOND HOUR_MINUTE HOUR_SECOND IF IGNORE IN INDEX INFILE INNER INOUT INSENSITIVE INSERT INT INT1 INT2 INT3 INT4 INT8 INTEGER INTERVAL INTO IS ITERATE JOIN KEY KEYS KILL |
LEADING LEAVE LEFT LIKE LIMIT LINEAR LINES LOAD LOCALTIME LOCALTIMESTAMP LOCK LONG LONGBLOB LONGTEXT LOOP LOW_PRIORITY MATCH MEDIUMBLOB MEDIUMINT MEDIUMTEXT MIDDLEINT MINUTE_MICROSECOND MINUTE_SECOND MOD MODIFIES NATURAL NO_WRITE_TO_BINLOG NOT NULL NUMERIC ON OPTIMIZE OPTION OPTIONALLY OR ORDER OUT OUTER OUTFILE PRECISION PRIMARY PROCEDURE PURGE |
RANGE READ READ_ONLY READ_WRITE READS REAL REFERENCES REGEXP RELEASE RENAME REPEAT REPLACE REQUIRE RESTRICT RETURN REVOKE RIGHT RLIKE SCHEMA SCHEMAS SECOND_MICROSECOND SELECT SENSITIVE SEPARATOR SET SHOW SMALLINT SPATIAL SPECIFIC SQL SQL_BIG_RESULT SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT SQLEXCEPTION SQLSTATE SQLWARNING SSL STARTING STRAIGHT_JOIN |
TABLE TERMINATED THEN TINYBLOB TINYINT TINYTEXT TO TRAILING TRIGGER TRUE UNDO UNION UNIQUE UNLOCK UNSIGNED UPDATE USAGE USE USING UTC_DATE UTC_TIME UTC_TIMESTAMP VALUES VARBINARY VARCHAR VARCHARACTER VARYING WHEN WHERE WHILE WITH WRITE X509 XOR YEAR_MONTH ZEROFILL |
This should have been simply dt, the data type symbol for date and time. It is used in the event definition. It could be a literal e.g. '1999-12-31 23:59:59', or a function or an expression.
| COLOR/FONT HTML/CSS JAVASCRIPT MAP SQL PHP |
prices store shipping SHOPPING CART
about contact articles tnar blog HOME |
|
| —— PRODUCTS —— | ||
|
||
| Color Lab Swatches Color Codes Color Wheel Color Blindness CMYK Popups Font Survey
HTML Tags Style Sheet Characters JavaScript Regular Expressions Country Codes Typing Tutor |
||
|
——— FREE ONLINE SERVICES ——— |
||
|
||