代码拉取完成,页面将自动刷新
{
"ID":4000,
"NAME":"COLUMN TYPE",
"COMMENT":"COLUMN TYPE",
"OR":true,
"C":[
{ "OPT":true,
"C":[
{"K":"_S_:BIT","F":"bitType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"bitTypeSize"},
{"K":"_C_:)"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:TINYINT","F":"tinyIntType"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{"OPT":true,"K":"_S_:BOOLEAN","F":"BoolType"},
{"OPT":true,"K":"_S_:BOOL","F":"BoolType"},
{
"OPT":true,
"C":[
{"K":"_S_:SMALLINT","F":"smallIntType"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:MEDIUMINT","F":"mediumIntType"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:INTEGER","F":"intType"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:INT","F":"intType"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:BIGINT","F":"bigIntType"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:DECIMAL","F":"decimalType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"floatSize"},
{"OPT":true,"C":[
{"K":"_C_:,"},
{"K":"_NUM_","F":"floatDigitsSize"}
]},
{"K":"_C_:)"}
]},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:FLOAT","F":"floatType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"floatSize"},
{"OPT":true,"C":[
{"K":"_C_:,"},
{"K":"_NUM_","F":"floatDigitsSize"}
]},
{"K":"_C_:)"}
]},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:DOUBLE","F":"doubleType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"floatSize"},
{"OPT":true,"C":[
{"K":"_C_:,"},
{"K":"_NUM_","F":"floatDigitsSize"}
]},
{"K":"_C_:)"}
]},
{"OPT":true,"K":"_S_:UNSIGNED","F":"numertypeIsUnsigned"},
{"OPT":true,"K":"_S_:ZEROFILL"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:DATETIME","F":"datetimeType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"datetimeTypePrec"},
{"K":"_C_:)"}
]}
]},
{"OPT":true,"K":"_S_:DATE","F":"dateType"},
{"OPT":true,
"C":[
{"K":"_S_:TIMESTAMP","F":"timestampType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"timestampTypePrec"},
{"K":"_C_:)"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:TIME","F":"timeType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"timeTypePrec"},
{"K":"_C_:)"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:YEAR","F":"yearType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"yearTypePrec"},
{"K":"_C_:)"}
]}
]},
{"OPT":true,
"C":[
{"OPT":true,"K":"_S_:NATIONAL"},
{"OR":true,"C":[
{"K":"_S_:CHAR","F":"charType"},
{"K":"_S_:VARCHAR","F":"varcharType"}
]},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"stringTypeSize"},
{"K":"_C_:)"}
]},
{"OPT":true,"C":[
{"K":"_S_:CHARACTER SET"},
{"K":"_AS_","F":"stringTypeCharSet"}
]},
{"OPT":true,"C":[
{"K":"_S_:COLLATE"},
{"K":"_AS_"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:BINARY","F":"binaryType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"stringTypeSize"},
{"K":"_C_:)"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:VARBINARY","F":"varbinaryType"},
{"OPT":true,"C":[
{"K":"_C_:("},
{"K":"_NUM_","F":"stringTypeSize"},
{"K":"_C_:)"}
]}
]},
{"OPT":true,"K":"_S_:TINYBLOB","F":"tinyBlobType"},
{"OPT":true,"K":"_S_:BLOB","F":"blobType"},
{"OPT":true,"K":"_S_:MEDIUMBLOB","F":"mediumBlobType"},
{"OPT":true,"K":"_S_:LONGBLOB","F":"longBlobtype"},
{"OPT":true,
"C":[
{"K":"_S_:TINYTEXT","F":"tinyTextType"},
{"OPT":true,"C":[
{"K":"_S_:CHARACTER SET"},
{"K":"_AS_","F":"stringTypeCharSet"}
]},
{"OPT":true,"C":[
{"K":"_S_:COLLATE"},
{"K":"_AS_"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:MEDIUMTEXT","F":"mediumTextType"},
{"OPT":true,"C":[
{"K":"_S_:CHARACTER SET"},
{"K":"_AS_","F":"stringTypeCharSet"}
]},
{"OPT":true,"C":[
{"K":"_S_:COLLATE"},
{"K":"_AS_"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:TEXT","F":"textType"},
{"OPT":true,"C":[
{"K":"_S_:CHARACTER SET"},
{"K":"_AS_","F":"stringTypeCharSet"}
]},
{"OPT":true,"C":[
{"K":"_S_:COLLATE"},
{"K":"_AS_"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:LONGTEXT","F":"longTexttype"},
{"OPT":true,"C":[
{"K":"_S_:CHARACTER SET"},
{"K":"_AS_","F":"stringTypeCharSet"}
]},
{"OPT":true,"C":[
{"K":"_S_:COLLATE"},
{"K":"_AS_"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:ENUM","F":"enumType"},
{"K":"_C_:("},
{"LOOP":true,"C":[
{"K":"_A_","F":"enumOrSetValueList"},
{"OPT":true,"K":"_C_:,"}
]},
{"K":"_C_:)"},
{"OPT":true,"C":[
{"K":"_S_:CHARACTER SET"},
{"K":"_AS_","F":"stringTypeCharSet"}
]},
{"OPT":true,"C":[
{"K":"_S_:COLLATE"},
{"K":"_AS_"}
]}
]},
{"OPT":true,
"C":[
{"K":"_S_:SET","F":"setType"},
{"K":"_C_:("},
{"LOOP":true,"C":[
{"K":"_A_","F":"enumOrSetValueList"},
{"OPT":true,"K":"_C_:,"}
]},
{"K":"_C_:)"},
{"OPT":true,"C":[
{"K":"_S_:CHARACTER SET"},
{"K":"_AS_","F":"stringTypeCharSet"}
]},
{"OPT":true,"C":[
{"K":"_S_:COLLATE"},
{"K":"_AS_"}
]}
]},
{"OPT":true,"K":"_S_:GEOMETRY","F":"geometryType"},
{"OPT":true,"K":"_S_:POINT","F":"geometryType"},
{"OPT":true,"K":"_S_:LINESTRING","F":"geometryType"},
{"OPT":true,"K":"_S_:JSON","F":"jsonType"}
]
}
{
"ID":20000,
"NAME":"DEFAULT VALUE",
"OPT":true,
"C":[
{"K":"_S_:DEFAULT"},
{"OR":true,
"C":[
{"C":[
{"K":"_NUM_"},
{"OPT":true,"C":[
{"K":"_C_:."},
{"K":"_NUM_"}
]}
]},
{"K":"_A_"},
{"OR":true,"LOOP":true,"C":[
{"C":[
{"K":"_S_:CURRENT_TIMESTAMP"},
{"OPT":true,"K":"_B_","COMMENT":"`gmt_create` timestamp(6) not null default current_timestamp(6)"}
]},
{"C":[
{"K":"_S_:ON"},
{"K":"_S_:UPDATE"},
{"K":"_S_:CURRENT_TIMESTAMP"},
{"OPT":true,"K":"_B_","COMMENT":"`gmt_create` timestamp(6) not null default current_timestamp(6)"}
]}
]},
{"C":[
{"K":"_AS_"},
{"K":"_B_"}
]},
{"OR":true,"C":[
{"K":"_S_:TRUE"},
{"K":"_S_:FALSE"}
]},
{"K":"_S_:NULL"},
{"K":"_N_"}
]}
]
}
{
"ID":0,
"NAME":"COLUMN INFO",
"LOOP":true,
"COMMENT":"COLUMN INFO",
"C":[
{"K":"_N_","COMMENT":"column name","F":"newColumn"},
{"INCLUDE":4000,"COMMENT":"column type"},
{
"OPT":true,
"OR":true,
"C":[
{"K":"_S_:NOT NULL"},
{"K":"_S_:NULL"}
]},
{"OPT":true,"C":[
{"OPT":true,"K":"_S_:GENERATED ALWAYS"},
{"K":"_S_:AS","F":"generatedColumn"},
{"K":"_B_"},
{"OPT":true,"C":[
{"K":"_S_:VIRTUAL"},
{"K":"_S_:STORED"}
]}
]},
{"INCLUDE":20000},
{"OPT":true,"K":"_S_:AUTO_INCREMENT"},
{"OPT":true,
"C":[
{"K":"_S_:UNIQUE","F":"columnIsUK"},
{"OPT":true,"K":"_S_:KEY"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:PRIMARY","F":"columnIsPK"},
{"OPT":true,"K":"_S_:KEY"}
]},
{"OPT":true,"K":"_S_:KEY","F":"columnIsKey"},
{
"OPT":true,
"C":[
{"K":"_S_:COMMENT"},
{"K":"_A_"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:COLUMN_FORMAT"},
{"K":"_AS_"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:STORAGE"},
{"K":"_AS_"}
]},
{
"OPT":true,
"C":[
{"K":"_S_:REFERENCES"},
{"K":"_N_"},
{"K":"_B_"},
{
"OPT":true,
"C":[
{"K":"_S_:MATCH"},
{
"OR":true,
"C":[
{"K":"_S_:FULL"},
{"K":"_S_:PARTIAL"},
{"K":"_S_:SIMPLE"}
]}
]},
{
"OPT":true,
"C":[
{"K":"_S_:ON"},
{
"OR":true,
"C":[
{"K":"_S_:DELETE"},
{"K":"_S_:UPDATE"}
]},
{
"OR":true,
"C":[
{"K":"_S_:RESTRICT"},
{"K":"_S_:CASCADE"},
{"K":"_S_:SET NULL"},
{"K":"_S_:NO ACTION"},
{"K":"_S_:SET DEFAULT"}
]}
]}
]}
]
}
{
"ID":1001,
"name":"index_option",
"OPT":true,
"OR":true,
"LOOP":true,
"C":[
{"OPT":true,
"C":[
{"K":"_S_:KEY_BLOCK_SIZE"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]
},
{"OPT":true,
"C":[
{"K":"_S_:USING"},
{"K":"_AS_"}
]
},
{"OPT":true,
"C":[
{"K":"_S_:WITH PARSER"},
{"K":"_AS_"}
]
},
{"OPT":true,
"C":[
{"K":"_S_:COMMENT"},
{"K":"_A_"}
]
},
{"OPT":true,"OR":true,
"C":[
{"K":"_S_:VISIBLE"},
{"K":"_S_:INVISIBLE"}
]
}
]
}
{
"ID":2001,
"COMMENT":"CONSTRAINT",
"LOOP":true,
"C":[
{
"OPT":true,
"C":[
{"K":"_S_:CONSTRAINT"},
{"OPT":true,"K":"_AS_","F":"constraintName"}
]
},
{
"OR":true,
"C":[
{
"C":[
{"K":"_S_:PRIMARY KEY","F":"primaryKeys"},
{"OPT":true,
"C":[
{"K":"_S_:USING"},
{"K":"_AS_"}
]},
{"K":"_C_:("},
{"LOOP":true,"C":[
{"K":"_N_","F":"keyColumn"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"OR":true,"C":[
{"K":"_S_:ASC"},
{"K":"_S_:DESC"}
]},
{"OPT":true,"K":"_C_:,"}
]},
{"K":"_C_:)"},
{"INCLUDE":1001}
]
},
{
"C":[
{"K":"_S_:UNIQUE","F":"uniqueKeys"},
{
"OR":true,
"C":[
{"K":"_S_:KEY"},
{"K":"_S_:INDEX"}
]
},
{"OPT":true,"K":"_N_","F":"uniqueKeyName"},
{"OPT":true,
"C":[
{"K":"_S_:USING"},
{"K":"_AS_"}
]},
{"K":"_C_:("},
{"LOOP":true,"C":[
{"K":"_N_","F":"keyColumn"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"OR":true,"C":[
{"K":"_S_:ASC"},
{"K":"_S_:DESC"}
]},
{"OPT":true,"K":"_C_:,"}
]},
{"K":"_C_:)"},
{"INCLUDE":1001}
]}
]
}
]
}
{
"ID":6000,
"NAME":"create_definition",
"LOOP":true,
"OPT":true,
"C":[
{ "OR":true,
"C":[
{"INCLUDE":0},
{"INCLUDE":2001},
{"OPT":true,
"C":[
{"OR":true,
"C":[
{"K":"_S_:KEY"},
{"K":"_S_:INDEX"}
]
},
{"OPT":true,"K":"_N_"},
{"OPT":true,
"C":[
{"K":"_S_:USING"},
{"K":"_AS_"}
]},
{"K":"_B_"},
{"INCLUDE":1001}
]
},
{"OPT":true,
"C":[
{"OR":true,
"C":[
{"K":"_S_:FULLTEXT"},
{"K":"_S_:SPATIAL"}
]
},
{"OR":true,"OPT":true,
"C":[
{"K":"_S_:KEY"},
{"K":"_S_:INDEX"}
]
},
{"OPT":true,"K":"_N_"},
{"K":"_B_"},
{"INCLUDE":1001}
]
}
]},
{"OPT":true,"K":"_C_:,"}
]
}
{
"ID":7000,
"LOOP":true,
"NAME":"table_options",
"OPT":true,
"OR":true,
"C":[
{"OPT":true,"C":[
{"K":"_S_:AUTO_INCREMENT"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:AVG_ROW_LENGTH"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"OPT":true,"K":"_S_:DEFAULT"},
{"OR":true,"C":[
{"C":[
{"OR":true,"C":[
{"K":"_S_:CHARACTER SET"},
{"K":"_S_:CHARSET"},
]},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_","F":"tableCharset"}
]},
{"C":[
{"K":"_S_:COLLATE"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]}
]}
]},
{"OPT":true,"C":[
{"K":"_S_:CHECKSUM"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:COMMENT"},
{"OPT":true,"K":"_C_:="},
{"K":"_A_"}
]},
{"OPT":true,"C":[
{"K":"_S_:COMPRESSION"},
{"OPT":true,"K":"_C_:="},
{"K":"_A_"}
]},
{"OPT":true,"C":[
{"K":"_S_:CONNECTION"},
{"OPT":true,"K":"_C_:="},
{"K":"_A_"}
]},
{"OPT":true,"C":[
{"OR":true,"C":[
{"K":"_S_:DATA"},
{"K":"_S_:INDEX"}
]},
{"K":"_S_:DIRECTORY"},
{"OPT":true,"K":"_C_:="},
{"K":"_A_"}
]},
{"OPT":true,"C":[
{"K":"_S_:DELAY_KEY_WRITE"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:ENCRYPTION"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:ENGINE"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:INSERT_METHOD"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:KEY_BLOCK_SIZE"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:MAX_ROWS"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:MIN_ROWS"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:PACK_KEYS"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:PASSWORD"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:ROW_FORMAT"},
{"OPT":true,"K":"_C_:="},
{"K":"_A_"}
]},
{"OPT":true,"C":[
{"K":"_S_:STATS_AUTO_RECALC"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:STATS_PERSISTENT"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:STATS_SAMPLE_PAGES"},
{"OPT":true,"K":"_C_:="},
{"K":"_A_"}
]},
{"OPT":true,"C":[
{"K":"_S_:TABLESPACE"},
{"K":"_AS_"},
{"OPT":true,"C":[
{"K":"_S_:STORAGE"},
{"K":"_AS_"}
]},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:UNION"},
{"OPT":true,"K":"_C_:="},
{"K":"_B_"}
]},
]
}
{
"ID":8000,
"NAME":"partition_options",
"OPT":true,
"OR":true,
"C":[
{"K":"_S_:PARTITION BY"},
{"OR":true,"C":[
{"OPT":true,"C":[
{"OPT":true,"K":"_S_:LINEAR"},
{"OR":true,"C":[
{"C":[
{"K":"_S_:HASH"},
{"K":"_B_"}
]},
{"C":[
{"K":"_S_:KEY"},
{"OPT":true,"C":[
{"K":"_S_:ALGORITHM"},
{"K":"_C_:="},
{"K":"_AS_"}
]},
{"K":"_B_"}
]}
]}
]},
{"C":[
{"OR":true,"C":[
{"K":"_S_:RANGE"},
{"K":"_S_:LIST"}
]},
{"OR":true,"C":[
{"K":"_B_"},
{"C":[
{"K":"_S_:COLUMNS"},
{"K":"_B_"}
]}
]}
]}
]},
{"OPT":true,"C":[
{"K":"_S_:PARTITIONS"},
{"K":"_AS_"}
]},
{"OPT":true,"C":[
{"K":"_S_:SUBPARTITION BY"},
{"OR":true,"C":[
{"OPT":true,"C":[
{"OPT":true,"K":"_S_:LINEAR"},
{"OR":true,"C":[
{"C":[
{"K":"_S_:HASH"},
{"K":"_B_"}
]},
{"C":[
{"K":"_S_:KEY"},
{"OPT":true,"C":[
{"K":"_S_:ALGORITHM"},
{"K":"_C_:="},
{"K":"_AS_"}
]},
{"K":"_B_"}
]}
]}
]}
]},
{"OPT":true,"C":[
{"K":"_S_:SUBPARTITIONS"},
{"K":"_AS_"}
]}
]},
{"K":"_B_"}
]
}
{
"ID":3000,
"END":true,
"HEAD":true,
"COMMENT":"CREATE TABLE",
"C":[
{"K":"_S_:CREATE"},
{"OPT":true,"K":"_S_:TEMPORARY"},
{"OR":true,
"C" : [
{"K":"_S_:TABLE","F":"newTable"},
{"K":"_S_:SEQUENCE","COMMENT":"in rds,CREATE SEQUENCE is just like CREATE TABLE","F":"newTable"}
]},
{"OPT":true,"K":"_S_:IF NOT EXISTS"},
{
"OR":true,
"C":[
{"OR":true,
"C":[
{
"COMMENT":"create table dbName.tableName",
"C":[
{"K":"_N_","F":"NewTableDBName"},
{"K":"_C_:."},
{"K":"_N_","F":"NewTableName"}
]},
{"K":"_N_","COMMENT":"create table tableName","F":"NewTableName"}
]}
]},
{
"OR":true,
"C":[
{
"C":[
{"K":"_S_:LIKE","F":"createTableLike"},
{
"OR":true,
"C":[
{
"C":[
{"K":"_N_","F":"NewTableLikedDBName"},
{"K":"_C_:."},
{"K":"_N_","F":"NewTableLikedTableName"}
]},
{"K":"_N_","F":"NewTableLikedTableName"}
]}
]},
{
"C":[
{"K":"_C_:("},
{"INCLUDE":6000},
{"K":"_C_:)"},
{"INCLUDE":7000}
]}
]},
{"OPT":true,"K":"_S_:;"}
]
}
{
"ID":10000,
"OPT":true,
"COMMENT":"alter table add column",
"C":[
{"K":"_S_:ADD"},
{"K":"_S_:COLUMN"},
{"INCLUDE":0},
{"OPT":true,"OR":true,"C":
[
{"K":"_S_:FIRST","F":"AlterNewColumnAtFirst"},
{"C":[
{"K":"_S_:AFTER"},
{"K":"_N_","F":"AlterNewColumnAfter"}
]}
]}
]
}
{
"ID":10010,
"OPT":true,
"COMMENT":"alter table add columns",
"C":[
{"K":"_S_:ADD"},
{"K":"_S_:COLUMN"},
{"K":"_C_:("},
{"INCLUDE":0},
{"K":"_C_:)"}
]
}
{
"ID":10020,
"OPT":true,
"COMMENT":"alter table MODIFY column",
"C":[
{"K":"_S_:MODIFY"},
{"OPT":true,"K":"_S_:COLUMN"},
{"INCLUDE":0},
{"OPT":true,"OR":true,"C":
[
{"K":"_S_:FIRST","F":"AlterNewColumnAtFirst"},
{"C":[
{"K":"_S_:AFTER"},
{"K":"_N_","F":"AlterNewColumnAfter"}
]}
]}
]
}
{
"ID":10030,
"OPT":true,
"COMMENT":"alter table add CONSTRAINT",
"C":[
{"K":"_S_:ADD"},
{"INCLUDE":2001}
]
}
{
"ID":10040,
"OPT":true,
"COMMENT":"alter table add key",
"C":[
{"K":"_S_:ADD"},
{"OR":true,
"C":[
{"K":"_S_:KEY"},
{"K":"_S_:INDEX"}
]},
{"LOOP":true,"C":[
{"OPT":true,"K":"_N_"},
{"OPT":true,
"C":[
{"K":"_S_:USING"},
{"K":"_AS_"}
]},
{"K":"_B_"},
{"INCLUDE":1001}
]}
]
}
{
"ID":10050,
"OPT":true,
"COMMENT":"alter table drop index",
"C":[
{"K":"_S_:DROP"},
{"OR":true,
"C":[
{"K":"_S_:KEY"},
{"K":"_S_:INDEX"}
]},
{"K":"_N_","F":"dropIndex"}
]
}
{
"ID":10060,
"OPT":true,
"COMMENT":"alter table change column",
"F":"alterChangeColumn",
"C":[
{"K":"_S_:CHANGE"},
{"OPT":true,"K":"_S_:COLUMN"},
{"K":"_N_","F":"alterChangeColumnName"},
{"INCLUDE":0},
{"OPT":true,"OR":true,"C":
[
{"K":"_S_:FIRST","F":"AlterNewColumnAtFirst"},
{"C":[
{"K":"_S_:AFTER"},
{"K":"_N_","F":"AlterNewColumnAfter"}
]}
]}
]
}
{
"ID":10070,
"OPT":true,
"COMMENT":"alter table drop column",
"C":[
{"K":"_S_:DROP"},
{"OPT":true,"K":"_S_:COLUMN"},
{"K":"_N_","F":"dropColumn"}
]
}
{
"ID":10080,
"OPT":true,
"COMMENT":"alter table drop primary key",
"C":[
{"K":"_S_:DROP"},
{"K":"_S_:PRIMARY"},
{"K":"_S_:KEY","F":"dropPrimaryKey"}
]
}
{
"ID":10090,
"OPT":true,
"COMMENT":"alter table drop foreign key",
"C":[
{"K":"_S_:DROP"},
{"K":"_S_:FOREIGN "},
{"K":"_S_:KEY"},
{"K":"_N_","F":"dropForeignKey"}
]
}
{
"ID":9000,
"NAME":"alter table",
"OPT":true,
"HEAD":true,
"C":[
{"K":"_S_:ALTER"},
{"K":"_S_:TABLE","F":"alterTable"},
{
"OR":true,
"C":[
{"OR":true,
"C":[
{
"COMMENT":"alter table dbName.tableName",
"C":[
{"K":"_N_","F":"alterTableDbName"},
{"K":"_C_:."},
{"K":"_N_","F":"alterTableTableName"}
]},
{"K":"_N_","COMMENT":"alter table tableName","F":"alterTableTableName"}
]}
]},
{
"LOOP":true,
"C":[
{"OR":true,"C":[
{"INCLUDE":10000},
{"INCLUDE":10010},
{"INCLUDE":10020},
{"INCLUDE":10030},
{"INCLUDE":10040},
{"INCLUDE":10050},
{"INCLUDE":10060},
{"INCLUDE":10070},
{"INCLUDE":10080},
{"INCLUDE":10090},
{"C":[
{"K":"_S_:COMMENT"},
{"OPT":true,"K":"_C_:="},
{"K":"_A_"}
]}
]},
{"OPT":true,"K":"_C_:,"}
]
},
{"OPT":true,"K":"_S_:;"}
]
}
{
"ID":12000,
"NAME":"create index",
"OPT":true,
"HEAD":true,
"C":[
{"K":"_S_:CREATE"},
{"OPT":true,"C":[
{"K":"_S_:ONINE"},
{"K":"_S_:OFFLINE"}
]},
{"OPT":true,"OR":true,"C":[
{"K":"_S_:UNIQUE","F":"createUK"},
{"K":"_S_:FULLTEXT"},
{"K":"_S_:SPATIAL"}
]},
{"K":"_S_:INDEX"},
{"K":"_N_","F":"createUKName"},
{"OPT":true,
"C":[
{"K":"_S_:USING"},
{"K":"_AS_"}
]
},
{"K":"_S_:ON"},
{"OR":true,
"C":[
{
"COMMENT":"dbName.tableName",
"C":[
{"K":"_N_","F":"createUKONDatabaseName"},
{"K":"_C_:."},
{"K":"_N_","F":"createUKONTableName"}
]},
{"K":"_N_","COMMENT":"tableName","F":"createUKONTableName"}
]},
{"K":"_C_:("},
{"LOOP":true,
"C":[
{"K":"_N_","F":"createUkByColumn"},
{"OPT":true,"K":"_B_"},
{"OPT":true,"C":[
{"K":"_S_:ASC"},
{"K":"_S_:DESC"}
]},
{"OPT":true,"K":"_C_:,"}
]},
{"K":"_C_:)"},
{"INCLUDE":1001},
{"OR":true,"OPT":true,"C":[
{"C":[
{"K":"_S_:ALGORITHM"},
{"OPT":true,"K":"_C_:="},
{"OR":true,"C":[
{"K":"_S_:DEFAULT"},
{"K":"_S_:INPLACE"},
{"K":"_S_:COPY"}
]}
]},
{"C":[
{"K":"_S_:LOCK"},
{"OPT":true,"K":"_C_:="},
{"OR":true,"C":[
{"K":"_S_:DEFAULT"},
{"K":"_S_:NONE"},
{"K":"_S_:EXCLUSIVE"},
{"K":"_S_:SHARED"}
]}
]}
]}
]
}
{
"ID":13000,
"NAME":"drop index",
"OPT":true,
"HEAD":true,
"C":[
{"K":"_S_:DROP"},
{"K":"_S_:INDEX"},
{"OPT":true,"C":[
{"K":"_S_:ONINE"},
{"K":"_S_:OFFLINE"}
]},
{"K":"_N_","F":"dropIndexName"},
{"K":"_S_:ON"},
{"OR":true,"C":[
{"COMMENT":"dbName.tableName",
"C":[
{"K":"_N_","F":"dropIndexOnDataBaseName"},
{"K":"_C_:."},
{"K":"_N_","F":"dropIndexOnTableName"}
]},
{"K":"_N_","COMMENT":"tableName","F":"dropIndexOnTableName"}
]},
{"OR":true,"OPT":true,"C":[
{"C":[
{"K":"_S_:ALGORITHM"},
{"OPT":true,"K":"_C_:="},
{"OR":true,"C":[
{"K":"_S_:DEFAULT"},
{"K":"_S_:INPLACE"},
{"K":"_S_:COPY"}
]}
]},
{"C":[
{"K":"_S_:LOCK"},
{"OPT":true,"K":"_C_:="},
{"OR":true,"C":[
{"K":"_S_:DEFAULT"},
{"K":"_S_:NONE"},
{"K":"_S_:EXCLUSIVE"},
{"K":"_S_:SHARED"}
]}
]}
]}
]
}
{
"ID":14000,
"NAME":"DROP TABLE",
"OPT":true,
"HEAD":true,
"C":[
{"K":"_S_:DROP"},
{"OPT":true,"K":"_S_:TEMPORARY"},
{"K":"_S_:TABLE","F":"dropTable"},
{"OPT":true,"K":"_S_:IF EXISTS"},
{"LOOP":true,"C":[
{"OR":true,"C":[
{"COMMENT":"dbName.tableName",
"C":[
{"K":"_N_","F":"dropTableDatabaseName"},
{"K":"_C_:.","F":"dropTableTableName"},
{"K":"_N_"}
]},
{"K":"_N_","COMMENT":"tableName","F":"dropTableTableName"}
]},
{"OPT":true,"K":"_C_:,"}
]},
{"OPT":true,"OR":true,"C":[
{"K":"_S_:RESTRICT"},
{"K":"_S_:CASCADE"}
]}
]
}
{
"ID":15000,
"NAME":"RENAME TABLE",
"OPT":true,
"HEAD":true,
"C":[
{"K":"_S_:RENAME"},
{"K":"_S_:TABLE"},
{"LOOP":true,"C":[
{"OR":true,"C":[
{"COMMENT":"dbName.tableName",
"C":[
{"K":"_N_","F":"renameTableDatabaseName"},
{"K":"_C_:."},
{"K":"_N_","F":"renameTableTableName"}
]},
{"K":"_N_","COMMENT":"tableName","F":"renameTableTableName"}
]},
{"K":"_S_:TO","F":"renameNewTable"},
{"OR":true,"C":[
{"COMMENT":"dbName.tableName",
"C":[
{"K":"_N_","F":"renameTableToDatabaseName"},
{"K":"_C_:."},
{"K":"_N_","F":"renameTableToTableName"}
]},
{"K":"_N_","COMMENT":"tableName","F":"renameTableToTableName"}
]},
{"OPT":true,"K":"_C_:,"}
]}
]
}
{
"ID":30000,
"name":"create database",
"HEAD":true,
"C":[
{"K":"_S_:CREATE"},
{"OR":true,"C":[
{"K":"_S_:DATABASE"},
{"K":"_S_:SCHEMA"}
]},
{"OPT":true,"K":"_S_:IF NOT EXISTS"},
{"K":"_N_","F":"createDatabase"},
{"OPT":true,"C":[
{"OPT":true,"K":"_S_:DEFAULT"},
{"K":"_S_:CHARACTER"},
{"K":"_S_:SET"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_","F":"databaseCharset"}
]},
{"OPT":true,"C":[
{"OPT":true,"K":"_S_:DEFAULT"},
{"K":"_S_:COLLATE"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]}
]
}
{
"ID":31000,
"name":"drop database",
"HEAD":true,
"C":[
{"K":"_S_:DROP"},
{"OR":true,"C":[
{"K":"_S_:DATABASE"},
{"K":"_S_:SCHEMA"}
]},
{"OPT":true,"K":"_S_:IF EXISTS"},
{"K":"_N_","F":"dropDatabase"}
]
}
{
"ID":32000,
"name":"alter database",
"HEAD":true,
"C":[
{"K":"_S_:ALTER"},
{"OR":true,"C":[
{"K":"_S_:DATABASE"},
{"K":"_S_:SCHEMA"}
]},
{"K":"_N_","F":"alterDatabase"},
{"OPT":true,"C":[
{"C":[
{"K":"_S_:UPGRADE DATA DIRECTORY"},
{"K":"_AS_"}
]},
{"C":[
{"OPT":true,"C":[
{"OPT":true,"K":"_S_:DEFAULT"},
{"K":"_S_:CHARACTER"},
{"K":"_S_:SET"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_","F":"databaseCharset"}
]},
{"OPT":true,"C":[
{"OPT":true,"K":"_S_:DEFAULT"},
{"K":"_S_:COLLATE"},
{"OPT":true,"K":"_C_:="},
{"K":"_AS_"}
]}
]}
]}
]
}
{
"ID":23000,
"name":"use database",
"HEAD":true,
"C":[
{"K":"_S_:USE"},
{"K":"_N_","F":"useDatabase"}
]
}
{
"ID":240001,
"name":"select column",
"OR":true,
"C":[
{"K":"_S_:*"},
{"C":[
{"K":"_S_:count"},
{"K":"_S_:("},
{"K":"_AS_"},
{"K":"_S_:)"}
]},
{"C":[
{"K":"_S_:sum"},
{"K":"_S_:("},
{"K":"_AS_"},
{"K":"_S_:)"}
]},
{"K":"_AS_"}
]
}
{
"ID":24000,
"name":"select"
"HEAD":true,
"C":[
{"K":"_S_:SELECT"},
{"OPT":true,"C":[
{"K":"_S_:STREAM"},
{"OPT":true,"C":[
{"K":"_S_:START"},
{"K":"_S_:FROM"},
{"OR":true,"C":[
{"C":[
{"KEY":"_S_:TIMESTAMP"},
{"K":"_NUM_"}
]},
{"C":[
{"KEY":"_S_:OFFSET"},
{"K":"_NUM_"}
]},
{"C":[
{"KEY":"_S_:ID"},
{"K":"_NUM_"}
]}
]}
]},
{"OPT":true,"C":[
{"K":"_S_:WINDOW"},
{"K":"_S_:SIZE"},
{"K":"_NUM_"}
]}
]}
{"OPT":true,"K":"_S_:DISTINCT"},
{"C":[
{"LOOP":true,"C":[
{"INCLUDE":2001},
{"KEY":"_S_:,"}
]}
{"INCLUDE":2001}
]},
{"K":"_S_:FROM"},
]
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。