“MySQL 语句:数据定义语句(DDL):“CREATE TABLESPACE”语句”的版本间差异

来自Wikioe
跳到导航 跳到搜索
(建立内容为“category:MySQL == 关于 ==”的新页面)
 
第2行: 第2行:


== 关于 ==
== 关于 ==
<syntaxhighlight lang="mysql">
CREATE TABLESPACE tablespace_name
  InnoDB and NDB:
    ADD DATAFILE 'file_name'
  InnoDB only:
    [FILE_BLOCK_SIZE = value]
  NDB only:
    USE LOGFILE GROUP logfile_group
    [EXTENT_SIZE [=] extent_size]
    [INITIAL_SIZE [=] initial_size]
    [AUTOEXTEND_SIZE [=] autoextend_size]
    [MAX_SIZE [=] max_size]
    [NODEGROUP [=] nodegroup_id]
    [WAIT]
    [COMMENT [=] 'string']
  InnoDB and NDB:
    [ENGINE [=] engine_name]
</syntaxhighlight>

2021年4月11日 (日) 19:01的版本


关于

CREATE TABLESPACE tablespace_name

  InnoDB and NDB:
    ADD DATAFILE 'file_name'

  InnoDB only:
    [FILE_BLOCK_SIZE = value]

  NDB only:
    USE LOGFILE GROUP logfile_group
    [EXTENT_SIZE [=] extent_size]
    [INITIAL_SIZE [=] initial_size]
    [AUTOEXTEND_SIZE [=] autoextend_size]
    [MAX_SIZE [=] max_size]
    [NODEGROUP [=] nodegroup_id]
    [WAIT]
    [COMMENT [=] 'string']

  InnoDB and NDB:
    [ENGINE [=] engine_name]