Alter Table

[ Up | Design | Data | Csv ]

Field Name Type Length Flags

   TABLE_CATALOG VAR_STRING 2048 not_null

   TABLE_SCHEMA VAR_STRING 256 not_null

   TABLE_NAME VAR_STRING 256 not_null

   TABLE_TYPE VAR_STRING 256 not_null

   ENGINE VAR_STRING 256

   VERSION LONGLONG 21

   ROW_FORMAT VAR_STRING 40

   TABLE_ROWS LONGLONG 21

   AVG_ROW_LENGTH LONGLONG 21

   DATA_LENGTH LONGLONG 21

   MAX_DATA_LENGTH LONGLONG 21

   INDEX_LENGTH LONGLONG 21

   DATA_FREE LONGLONG 21

   AUTO_INCREMENT LONGLONG 21

   CREATE_TIME DATETIME 19

   UPDATE_TIME DATETIME 19

   CHECK_TIME DATETIME 19

   TABLE_COLLATION VAR_STRING 128

   CHECKSUM LONGLONG 21

   CREATE_OPTIONS VAR_STRING 8192

   TABLE_COMMENT VAR_STRING 8192 not_null

   MAX_INDEX_LENGTH LONGLONG 21

   TEMPORARY VAR_STRING 4

Add Field New Field

	Field Name	Type	Length	Flags
	TABLE_CATALOG	VAR_STRING	2048	not_null
	TABLE_SCHEMA	VAR_STRING	256	not_null
	TABLE_NAME	VAR_STRING	256	not_null
	TABLE_TYPE	VAR_STRING	256	not_null
	ENGINE	VAR_STRING	256
	VERSION	LONGLONG	21
	ROW_FORMAT	VAR_STRING	40
	TABLE_ROWS	LONGLONG	21
	AVG_ROW_LENGTH	LONGLONG	21
	DATA_LENGTH	LONGLONG	21
	MAX_DATA_LENGTH	LONGLONG	21
	INDEX_LENGTH	LONGLONG	21
	DATA_FREE	LONGLONG	21
	AUTO_INCREMENT	LONGLONG	21
	CREATE_TIME	DATETIME	19
	UPDATE_TIME	DATETIME	19
	CHECK_TIME	DATETIME	19
	TABLE_COLLATION	VAR_STRING	128
	CHECKSUM	LONGLONG	21
	CREATE_OPTIONS	VAR_STRING	8192
	TABLE_COMMENT	VAR_STRING	8192	not_null
	MAX_INDEX_LENGTH	LONGLONG	21
	TEMPORARY	VAR_STRING	4
New Field