CREATE TABLE Syntax

SQL语句创建表格详解

最新推荐文章于 2024-10-28 08:15:00 发布

原创最新推荐文章于 2024-10-28 08:15:00 发布 · 257 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #HTML

本文深入解析SQL中创建表格的语法，包括基本语法、临时表格、静默列指定变化等，提供创建定义、约束、索引等详细操作指南。

CREATE TABLE Syntax

12.1.17.1. Silent Column Specification Changes
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
(create_definition,...)
[table_options]
[partition_options]

Or:
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
[(create_definition,...)]
[table_options]
[partition_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_option] ...
| {INDEX|KEY} [index_name] [index_type] (index_col_name,...)
[index_option] ...
| [CONSTRAINT [symbol]] UNIQUE [INDEX|KEY]
[index_name] [index_type] (index_col_name,...)
[index_option] ...
| {FULLTEXT|SPATIAL} [INDEX|KEY] [index_name] (index_col_name,...)
[index_option] ...
| [CONSTRAINT [symbol]] FOREIGN KEY
[index_name] (index_col_name,...) reference_definition
| CHECK (expr)

[url]http://dev.mysql.com/doc/refman/5.1/en/create-table.html[/url]