![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961049.webp)
CREATE TABLE
Syntax
1029
Before MySQL 5.0.18, parameters, return values, and local variables are treated as items in
expressions, and are subject to automatic (silent) conversion and truncation. Stored functions ignore
the
sql_mode
[495]
setting.
13.1.10.
CREATE TABLE
Syntax
CREATE [TEMPORARY] TABLE [IF NOT EXISTS]
tbl_name
(
create_definition
,...)
[
table_options
]
Or:
CREATE [TEMPORARY] TABLE [IF NOT EXISTS]
tbl_name
[(
create_definition
,...)]
[
table_options
]
select_statement
Or:
CREATE [TEMPORARY] TABLE [IF NOT EXISTS]
tbl_name
{ LIKE
old_tbl_name
| (LIKE
old_tbl_name
) }
create_definition
:
col_name
column_definition
| [CONSTRAINT [
symbol
]] PRIMARY KEY [
index_type
] (
index_col_name
,...)
[
index_type
]
| {INDEX|KEY} [
index_name
] [
index_type
] (
index_col_name
,...)
[
index_type
]
| [CONSTRAINT [
symbol
]] UNIQUE [INDEX|KEY]
[
index_name
] [
index_type
] (
index_col_name
,...)
[
index_type
]
| {FULLTEXT|SPATIAL} [INDEX|KEY] [
index_name
] (
index_col_name
,...)
[
index_type
]
| [CONSTRAINT [
symbol
]] FOREIGN KEY
[
index_name
] (
index_col_name
,...)
reference_definition
| CHECK (
expr
)
column_definition
:
data_type
[NOT NULL | NULL] [DEFAULT
default_value
]
[AUTO_INCREMENT] [UNIQUE [KEY] | [PRIMARY] KEY]
[COMMENT '
string
'] [
reference_definition
]
data_type
:
BIT[(
length
)]
| TINYINT[(
length
)] [UNSIGNED] [ZEROFILL]
| SMALLINT[(
length
)] [UNSIGNED] [ZEROFILL]
| MEDIUMINT[(
length
)] [UNSIGNED] [ZEROFILL]
| INT[(
length
)] [UNSIGNED] [ZEROFILL]
| INTEGER[(
length
)] [UNSIGNED] [ZEROFILL]
| BIGINT[(
length
)] [UNSIGNED] [ZEROFILL]
| REAL[(
length
,
decimals
)] [UNSIGNED] [ZEROFILL]
| DOUBLE[(
length
,
decimals
)] [UNSIGNED] [ZEROFILL]
| FLOAT[(
length
,
decimals
)] [UNSIGNED] [ZEROFILL]
| DECIMAL[(
length
[,
decimals
])] [UNSIGNED] [ZEROFILL]
| NUMERIC[(
length
[,
decimals
])] [UNSIGNED] [ZEROFILL]
| DATE
| TIME
| TIMESTAMP
| DATETIME
| YEAR
| CHAR[(
length
)]
[CHARACTER SET
charset_name
] [COLLATE
collation_name
]
| VARCHAR(
length
)
[CHARACTER SET
charset_name
] [COLLATE
collation_name
]
| BINARY[(
length
)]
| VARBINARY(
length
)
| TINYBLOB
| BLOB
| MEDIUMBLOB
| LONGBLOB
| TINYTEXT [BINARY]
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...