java.lang.Object
- com.alibaba.druid.sql.ast.SQLObjectImpl
- - com.alibaba.druid.sql.ast.SQLStatementImpl
  - - com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement
    - - com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlCreateTableStatement

All Implemented Interfaces:

SQLDbTypedObject, SQLObject, SQLStatement, SQLCreateStatement, SQLDDLStatement, MySqlObject, MySqlStatement
```
public class MySqlCreateTableStatement
extends SQLCreateTableStatement
implements MySqlStatement
```

Nested Class Summary

Nested Classes
Modifier and Type Class Description

static class MySqlCreateTableStatement.TableSpaceOption
- Nested classes/interfaces inherited from class com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement
  SQLCreateTableStatement.Feature
- Nested classes/interfaces inherited from interface com.alibaba.druid.sql.ast.statement.SQLDDLStatement
  SQLDDLStatement.DDLObjectType

Field Summary

Fields
Modifier and Type	Field	Description
`protected SQLName`	`archiveBy`
`protected SQLExpr`	`dbPartitionBy`
`protected SQLExpr`	`dbPartitions`
`protected List<SQLName>`	`distributeBy`
`protected SQLName`	`distributeByType`
`protected MySqlExtPartition`	`exPartition`
`protected boolean`	`isBroadCast`
`protected Boolean`	`single`
`protected SQLName`	`storedBy`
`protected SQLExpr`	`tablePartitionBy`
`protected SQLExpr`	`tablePartitions`
`protected Map<String,SQLName>`	`with`
`protected Boolean`	`withData`
`protected SQLStatement`	`withSelect`

Fields inherited from class com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement
buckets, clusteredBy, clusteringType, comment, compress, engine, features, ignore, inherits, isAutoBucket, lifeCycle, like, localPartitioning, location, logging, onCommitDeleteRows, onCommitPreserveRows, orderBy, partitionBy, partitionColumns, partitionOf, replace, rowFormat, select, shards, sortedBy, storedAs, tableElementList, tableOptions, tableSource, tablespace, unique

Fields inherited from class com.alibaba.druid.sql.ast.SQLStatementImpl
afterSemi, dbType, headHints

Fields inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl
attributes, hint, parent, sourceColumn, sourceLine

Constructor Summary

Constructors
Constructor Description

MySqlCreateTableStatement()

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method	Description
`void`	`accept0(MySqlASTVisitor visitor)`
`protected void`	`accept0(SQLASTVisitor visitor)`
`protected boolean`	`alterApply(SQLAlterTableItem item)`
`boolean`	`apply(SQLAlterCharacter item)`
`boolean`	`apply(SQLAlterTableAddIndex item)`
`boolean`	`apply(MySqlAlterTableAlterColumn x)`
`boolean`	`apply(MySqlAlterTableChangeColumn item)`
`boolean`	`apply(MySqlAlterTableModifyColumn item)`
`boolean`	`apply(MySqlAlterTableOption item)`
`boolean`	`apply(MySqlRenameTableStatement x)`
`boolean`	`apply(MySqlRenameTableStatement.Item item)`
`MySqlCreateTableStatement`	`clone()`
`void`	`cloneTo(MySqlCreateTableStatement x)`
`SQLName`	`getArchiveBy()`
`SQLExpr`	`getDbPartitionBy()`
`SQLExpr`	`getDbpartitions()`
`SQLExpr`	`getDbPartitions()`
`List<SQLName>`	`getDistributeBy()`
`SQLName`	`getDistributeByType()`
`SQLExpr`	`getEngine()`
`MySqlExtPartition`	`getExtPartition()`
`List<SQLCommentHint>`	`getHints()`
`List<MySqlTableIndex>`	`getMysqlIndexes()`
`List<MySqlKey>`	`getMysqlKeys()`
`List<SQLCommentHint>`	`getOptionHints()`
`SQLSelect`	`getQuery()`	Deprecated.
`Boolean`	`getSingle()`
`SQLName`	`getStoredBy()`
`SQLName`	`getTableGroup()`
`SQLExpr`	`getTablePartitionBy()`
`SQLExpr`	`getTablePartitions()`
`SQLExpr`	`getTbpartitions()`
`Map<String,SQLName>`	`getWith()`
`Boolean`	`getWithData()`
`SQLStatement`	`getWithSelect()`
`boolean`	`isBroadCast()`
`void`	`setArchiveBy(SQLName archiveBy)`
`void`	`setBroadCast(boolean broadCast)`
`void`	`setDbPartitionBy(SQLExpr x)`
`void`	`setDbPartitions(SQLExpr x)`
`void`	`setDistributeByType(SQLName distributeByType)`
`void`	`setEngine(SQLExpr x)`
`void`	`setExPartition(MySqlExtPartition x)`
`void`	`setHints(List<SQLCommentHint> hints)`
`void`	`setOptionHints(List<SQLCommentHint> optionHints)`
`void`	`setPageChecksum(SQLExpr x)`
`void`	`setQuery(SQLSelect query)`	Deprecated.
`void`	`setSingle(Boolean single)`
`void`	`setStoredBy(SQLName storedBy)`
`void`	`setTableGroup(SQLName tableGroup)`
`void`	`setTableGroup(String tableGroup)`
`void`	`setTablePartitionBy(SQLExpr x)`
`void`	`setTablePartitions(SQLExpr x)`
`void`	`setTransactional(SQLExpr x)`
`void`	`setWithData(Boolean withData)`
`void`	`setWithSelect(SQLStatement withSelect)`
`void`	`showColumns(StringBuilder out)`
`void`	`simplify()`

Methods inherited from class com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement
acceptChild, addBodyBeforeComment, addClusteredByItem, addColumn, addColumn, addColumn, addOption, addPartitionColumn, addSortedByItem, addTblProperty, apply, apply, apply, apply, cloneTo, columnIndexOf, computeName, config, config, containsColumn, containsDuplicateColumnNames, containsDuplicateColumnNames, findColumn, findColumn, findForeignKey, findIndex, findPrimaryKey, findUnique, forEachColumn, foreignKeyToAlterTable, getBodyBeforeCommentsDirect, getBuckets, getCatalog, getChildren, getClusteredBy, getClusteringType, getColumn, getColumnComments, getColumnDefinitions, getColumnNames, getComment, getCompress, getDDLObjectType, getInherits, getLifeCycle, getLike, getLocalPartitioning, getLocation, getLogging, getName, getOption, getOptionOrTblPropertyValue, getOptionValue, getOrderBy, getPartitionColumns, getPartitioning, getPartitionOf, getPrimaryKeyNames, getRowFormat, getSchema, getSelect, getShards, getSortedBy, getStoredAs, getTableElementList, getTableName, getTableOptions, getTableSource, getTablespace, getTblProperties, getTblProperty, getTblPropertyValue, getUnique, hasBodyBeforeComment, hashForeignKey, isAutoBucket, isDimension, isEnabled, isExternal, isIfNotExists, isIgnore, isMUL, isOnCommitPreserveRows, isOnlyPrimaryKey, isPrimaryColumn, isPrimaryColumn, isReferenced, isReferenced, isReplace, isSingle, isTemporary, isUNI, removeOption, renameColumn, setAutoBucket, setBuckets, setClusteringType, setComment, setCompress, setDimension, setExternal, setIfNotExists, setIgnore, setInherits, setLifeCycle, setLike, setLike, setLocalPartitioning, setLocation, setLogging, setName, setName, setOnCommitPreserveRows, setOrderBy, setPartitionBy, setPartitionOf, setReplace, setRowFormat, setSchema, setSelect, setShards, setSingle, setStoredAs, setStoredBy, setTableName, setTableSource, setTablespace, setTemporary, setUnique, sort, toString

Methods inherited from class com.alibaba.druid.sql.ast.SQLStatementImpl
cloneTo, getDbType, getHeadHintsDirect, isAfterSemi, setAfterSemi, setDbType, setHeadHints, toLowerCaseString, toParameterizedString, toString, toUnformattedString

Methods inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl
accept, acceptChild, acceptChild, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, cloneTo, computeDataType, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getHint, getParent, getParent, getSourceColumn, getSourceLine, hasAfterComment, hasBeforeComment, output, putAttribute, setHint, setParent, setSource, setSourceLine

Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.alibaba.druid.sql.ast.SQLObject
accept, addAfterComment, addAfterComment, addBeforeComment, addBeforeComment, containsAttribute, getAfterCommentsDirect, getAttribute, getAttributes, getAttributesDirect, getBeforeCommentsDirect, getParent, getParent, getSourceColumn, getSourceLine, hasAfterComment, hasBeforeComment, output, putAttribute, setParent, setSource

Methods inherited from interface com.alibaba.druid.sql.ast.SQLStatement
getChildren, getDbType, getHeadHintsDirect, isAfterSemi, setAfterSemi, setHeadHints, toLowerCaseString, toParameterizedString, toString, toString

Field Detail

dbPartitionBy
```
protected SQLExpr dbPartitionBy
```

dbPartitions
```
protected SQLExpr dbPartitions
```

tablePartitionBy
```
protected SQLExpr tablePartitionBy
```

tablePartitions
```
protected SQLExpr tablePartitions
```

exPartition

protected MySqlExtPartition exPartition

storedBy
```
protected SQLName storedBy
```

distributeByType
```
protected SQLName distributeByType
```

distributeBy
```
protected List<SQLName> distributeBy
```

isBroadCast
```
protected boolean isBroadCast
```

with
```
protected Map<String,SQLName> with
```

withSelect
```
protected SQLStatement withSelect
```

archiveBy
```
protected SQLName archiveBy
```

withData
```
protected Boolean withData
```

single
```
protected Boolean single
```

Constructor Detail
- MySqlCreateTableStatement
```
public MySqlCreateTableStatement()
```

Method Detail

getHints

public List<SQLCommentHint> getHints()

setHints

public void setHints(List<SQLCommentHint> hints)

getWithSelect
```
public SQLStatement getWithSelect()
```

setWithSelect

public void setWithSelect(SQLStatement withSelect)

getQuery

@Deprecated
public SQLSelect getQuery()

Deprecated.

setQuery

@Deprecated
public void setQuery(SQLSelect query)

Deprecated.

accept0
```
protected void accept0(SQLASTVisitor visitor)
```
Overrides:

accept0 in class SQLCreateTableStatement

accept0

public void accept0(MySqlASTVisitor visitor)

Specified by:: accept0 in interface MySqlObject

getOptionHints

public List<SQLCommentHint> getOptionHints()

setOptionHints

public void setOptionHints(List<SQLCommentHint> optionHints)

getTableGroup
```
public SQLName getTableGroup()
```

setTableGroup

public void setTableGroup(SQLName tableGroup)

setTableGroup

public void setTableGroup(String tableGroup)

simplify
```
public void simplify()
```
Overrides:

simplify in class SQLCreateTableStatement

showColumns

public void showColumns(StringBuilder out)
                 throws IOException

Throws:: IOException

getMysqlKeys
```
public List<MySqlKey> getMysqlKeys()
```

getMysqlIndexes

public List<MySqlTableIndex> getMysqlIndexes()

apply

public boolean apply(MySqlRenameTableStatement x)

alterApply
```
protected boolean alterApply(SQLAlterTableItem item)
```
Overrides:

alterApply in class SQLCreateTableStatement

apply

public boolean apply(SQLAlterTableAddIndex item)

Overrides:: apply in class SQLCreateTableStatement

apply

public boolean apply(MySqlAlterTableOption item)

apply

public boolean apply(SQLAlterCharacter item)

apply

public boolean apply(MySqlRenameTableStatement.Item item)

apply

public boolean apply(MySqlAlterTableAlterColumn x)

apply

public boolean apply(MySqlAlterTableChangeColumn item)

apply

public boolean apply(MySqlAlterTableModifyColumn item)

cloneTo

public void cloneTo(MySqlCreateTableStatement x)

clone
```
public MySqlCreateTableStatement clone()
```
Specified by:

clone in interface SQLObject

Specified by:

clone in interface SQLStatement

Overrides:

clone in class SQLCreateTableStatement

getDbPartitionBy
```
public SQLExpr getDbPartitionBy()
```

setDbPartitionBy

public void setDbPartitionBy(SQLExpr x)

getTablePartitionBy
```
public SQLExpr getTablePartitionBy()
```

setTablePartitionBy

public void setTablePartitionBy(SQLExpr x)

getDistributeByType
```
public SQLName getDistributeByType()
```

setDistributeByType

public void setDistributeByType(SQLName distributeByType)

getDistributeBy

public List<SQLName> getDistributeBy()

getTbpartitions
```
public SQLExpr getTbpartitions()
```

getTablePartitions
```
public SQLExpr getTablePartitions()
```

setTablePartitions

public void setTablePartitions(SQLExpr x)

getDbpartitions
```
public SQLExpr getDbpartitions()
```

setDbPartitions

public void setDbPartitions(SQLExpr x)

getExtPartition

public MySqlExtPartition getExtPartition()

setExPartition

public void setExPartition(MySqlExtPartition x)

getDbPartitions
```
public SQLExpr getDbPartitions()
```

getStoredBy
```
public SQLName getStoredBy()
```
Overrides:

getStoredBy in class SQLCreateTableStatement

setStoredBy

public void setStoredBy(SQLName storedBy)

getWith

public Map<String,SQLName> getWith()

isBroadCast
```
public boolean isBroadCast()
```

setBroadCast

public void setBroadCast(boolean broadCast)

getArchiveBy
```
public SQLName getArchiveBy()
```

setArchiveBy

public void setArchiveBy(SQLName archiveBy)

getWithData
```
public Boolean getWithData()
```

setWithData

public void setWithData(Boolean withData)

getEngine
```
public SQLExpr getEngine()
```
Overrides:

getEngine in class SQLCreateTableStatement

setEngine
```
public void setEngine(SQLExpr x)
```
Overrides:

setEngine in class SQLCreateTableStatement

setPageChecksum

public void setPageChecksum(SQLExpr x)

setTransactional

public void setTransactional(SQLExpr x)

getSingle
```
public Boolean getSingle()
```

setSingle

public void setSingle(Boolean single)

Class MySqlCreateTableStatement

Nested Class Summary

Nested classes/interfaces inherited from class com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement

Nested classes/interfaces inherited from interface com.alibaba.druid.sql.ast.statement.SQLDDLStatement

Field Summary

Fields inherited from class com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement

Fields inherited from class com.alibaba.druid.sql.ast.SQLStatementImpl

Fields inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl

Constructor Summary

Method Summary

Methods inherited from class com.alibaba.druid.sql.ast.statement.SQLCreateTableStatement

Methods inherited from class com.alibaba.druid.sql.ast.SQLStatementImpl

Methods inherited from class com.alibaba.druid.sql.ast.SQLObjectImpl

Methods inherited from class java.lang.Object

Methods inherited from interface com.alibaba.druid.sql.ast.SQLObject

Methods inherited from interface com.alibaba.druid.sql.ast.SQLStatement

Field Detail

dbPartitionBy

dbPartitions

tablePartitionBy

tablePartitions

exPartition

storedBy

distributeByType

distributeBy

isBroadCast

with

withSelect

archiveBy

withData

single

Constructor Detail

MySqlCreateTableStatement

Method Detail

getHints

setHints

getWithSelect

setWithSelect

getQuery

setQuery

accept0

accept0

getOptionHints

setOptionHints

getTableGroup

setTableGroup

setTableGroup

simplify

showColumns

getMysqlKeys

getMysqlIndexes

apply

alterApply

apply

apply

apply

apply

apply

apply

apply

cloneTo

clone

getDbPartitionBy

setDbPartitionBy

getTablePartitionBy

setTablePartitionBy

getDistributeByType

setDistributeByType

getDistributeBy

getTbpartitions

getTablePartitions

setTablePartitions

getDbpartitions

setDbPartitions

getExtPartition

setExPartition

getDbPartitions

getStoredBy

setStoredBy

getWith