(mysql.info.gz) MaxDB Reserved Words
Info Catalog
(mysql.info.gz) MaxDB-MySQL Interoperability
(mysql.info.gz) MaxDB
17.7 Reserved Words in MaxDB
============================
Like MySQL, MaxDB has a number of reserved words that have special
meanings. Normally, they cannot be used as names of identifiers, such
as database or table names. The following table lists reserved words in
MaxDB, indicates the context in which those words are used, and
indicates whether or not they have counterparts in MySQL. If such a
counterpart exists, the meaning in MySQL might be identical or
differing in some aspects. The main purpose is to list in which
respects MaxDB differs from MySQL; therefore, this list is not complete.
For the list of reserved words in MySQL, see Reserved words.
*Reserved in *Context of usage in *MySQL counterpart*
MaxDB* MaxDB*
`@' Can prefix Not allowed
identifier, like
"@table"
`ADDDATE()' SQL function `ADDDATE()'; new in MySQL 4.1.1
`ADDTIME()' SQL function `ADDTIME()'; new in MySQL 4.1.1
`ALPHA' SQL function Nothing comparable
`ARRAY' Data type Not implemented
`ASCII()' SQL function `ASCII()', but implemented with a
different meaning
`AUTOCOMMIT' Transactions; `ON' by Transactions; `OFF' by default
default
`BOOLEAN' Column types; `BOOLEAN' was added in MySQL 4.1.0;
`BOOLEAN' accepts as it is a synonym for `BOOL' which is
values only `TRUE', mapped to `TINYINT(1)'. It accepts
`FALSE', and `NULL' integer values in the same range as
`TINYINT' as well as `NULL'. `TRUE'
and `FALSE' can be used as aliases
for `1' and `0'.
`CHECK' `CHECK TABLE' `CHECK TABLE'; similar, but not
identical usage
`COLUMN' Column types `COLUMN'; noise word
`CHAR()' SQL function `CHAR()'; identical syntax;
similar, not identical usage
`COMMIT' Implicit commits of Implicit commits of transactions
transactions happen happen when data definition
when data definition statements are issued, and also
statements are issued with a number of other statements
`COSH()' SQL function Nothing comparable
`COT()' SQL function `COT()'; identical syntax and
implementation
`CREATE' SQL, data definition `CREATE'
language
`DATABASE' SQL function `DATABASE()'; `DATABASE' is used in
a different context; for example,
`CREATE DATABASE'
`DATE()' SQL function `CURRENT_DATE'
`DATEDIFF()' SQL function `DATEDIFF()'; new in MySQL 4.1.1
`DAY()' SQL function Nothing comparable
`DAYOFWEEK()' SQL function `DAYOFWEEK()'; by default, `1'
represents Monday in MaxDB and
Sunday in MySQL
`DISTINCT' SQL functions `AVG', `DISTINCT'; but used in a different
`MAX', `MIN', `SUM' context: `SELECT DISTINCT'
`DROP' `DROP INDEX', for `DROP INDEX'; similar, but not
example identical usage
`EBCDIC()' SQL function Nothing comparable
`EXPAND()' SQL function Nothing comparable
`EXPLAIN' Optimization `EXPLAIN'; similar, but not
identical usage
`FIXED()' SQL function Nothing comparable
`FLOAT()' SQL function Nothing comparable
`HEX()' SQL function `HEX()'; similar, but not identical
usage
`INDEX()' SQL function `INSTR()' or `LOCATE()'; similar,
but not identical syntaxes and
meanings
`INDEX' `USE INDEX', `IGNORE `USE INDEX', `IGNORE INDEX' and
INDEX' and similar similar hints are used in the
hints are used right `FROM' clause of a `SELECT' query;
after `SELECT'; for for example, in `SELECT ... FROM
example, `SELECT ... ... USE INDEX'
USE INDEX'
`INITCAP()' SQL function Nothing comparable
`LENGTH()' SQL function `LENGTH()'; identical syntax, but
slightly different implementation
`LFILL()' SQL function Nothing comparable
`LIKE' Comparisons `LIKE'; but the extended `LIKE'
MaxDB provides rather resembles the
MySQL `REGEX'
`LIKE' MaxDB supports "%", MySQL supports "%", and "_" as
wildcards "_", wildcards in `LIKE' comparisons
"Control-underline",
"Control-up arrow",
"*", and "?" as
wildcards in `LIKE'
comparisons
`LPAD()' SQL function `LPAD()'; slightly different
implementation
`LTRIM()' SQL function `LTRIM()'; slightly different
implementation
`MAKEDATE()' SQL function `MAKEDATE()'; new in MySQL 4.1.1
`MAKETIME()' SQL function `MAKETIME()'; new in MySQL 4.1.1
`MAPCHAR()' SQL function Nothing comparable
`MICROSECOND()'SQL function `MICROSECOND()'; new in MySQL 4.1.1
`NOROUND()' SQL function Nothing comparable
`NULL' Column types; `NULL'; MaxDB supports special
comparisons `NULL' values that are returned by
arithmetic operations that lead to
an overflow or a division by zero;
MySQL does not support such special
values
`PI' SQL function `PI()'; identical syntax and
implementation, but parentheses are
mandatory in MySQL
`REF' Data type Nothing comparable
`RFILL()' SQL function Nothing comparable
`ROWNO' Predicate in `WHERE' Similar to `LIMIT' clause
clause
`RPAD()' SQL function `RPAD()'; slightly different
implementation
`RTRIM()' SQL function `RTRIM()'; slightly different
implementation
`SEQUENCE' `CREATE SEQUENCE', `AUTO_INCREMENT'; similar concept,
`DROP SEQUENCE' but different implementation
`SINH()' SQL function Nothing comparable
`SOUNDS()' SQL function `SOUNDEX()'; slightly different
syntax
`STATISTICS' `UPDATE STATISTICS' `ANALYZE TABLE'; similar concept,
but different implementation
`SUBSTR()' SQL function `SUBSTRING()'; slightly different
implementation
`SUBTIME()' SQL function `SUBTIME()'; new in MySQL 4.1.1
`SYNONYM' Data definition Nothing comparable
language: `CREATE
[PUBLIC] SYNONYM',
`RENAME SYNONYM',
`DROP SYNONYM'
`TANH()' SQL function Nothing comparable
`TIME()' SQL function `CURRENT_TIME'
`TIMEDIFF()' SQL function `TIMEDIFF()'; new in MySQL 4.1.1
`TIMESTAMP()' SQL function `TIMESTAMP()'; new in MySQL 4.1.1
`TIMESTAMP()' SQL function Nothing comparable
as argument
to
`DAYOFMONTH()'
and
`DAYOFYEAR()'
`TIMEZONE()' SQL function Nothing comparable
`TRANSACTION()'Returns the ID of the Nothing comparable
current transaction
`TRANSLATE()' SQL function `REPLACE()'; identical syntax and
implementation
`TRIM()' SQL function `TRIM()'; slightly different
implementation
`TRUNC()' SQL function `TRUNCATE()'; slightly different
syntax and implementation
`USE' Switches to a new `USE'; identical syntax, but does
database instance; not terminate the connection to the
terminates the current database
connection to the
current database
instance; all
subsequent commands
are referred to this
database instance
`USER' SQL function `USER()'; identical syntax, but
slightly different implementation,
and parentheses are mandatory in
MySQL
`UTC_DIFF()' SQL function `UTC_DATE()'; provides a means to
calculate the same result as
`UTC_DIFF()'
`VALUE()' SQL function, alias `COALESCE()'; identical syntax and
for `COALESCE()' implementation
`VARIANCE()' SQL function `VARIANCE()'; new in MySQL 4.1.0
`WEEKOFYEAR()' SQL function `WEEKOFYEAR()'; new in MySQL 4.1.1
Info Catalog
(mysql.info.gz) MaxDB-MySQL Interoperability
(mysql.info.gz) MaxDB
automatically generated byinfo2html