Mysql数据库字段建表问题

字段名：sex
类型 tinyint
无符号（默认0）0 新建 1发布 2删除
语法怎么写

如果是新建表建表
CREATE TABLE student (
id int(10) NOT NULL AUTO_INCREMENT,
sex tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

如果是已有表新加入set字段
ALTER TABLE student ADD sex TINGINT NOT NULL DEFAULT 0

如果是新建表建表
CREATE TABLE student (
id int(10) NOT NULL AUTO_INCREMENT,
**sex tinyint(4) NOT NULL DEFAULT '0',**
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

如果是已有表新加入set字段
ALTER TABLE student ADD sex TINGINT NOT NULL DEFAULT 0

CREATE TABLE t_sex (
sex tinyint(4) DEFAULT '0' COMMENT '0 新建 1发布 2删除'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

CREATE TABLE t1(
sex varchar not null,
);

CREATE TABLENAME(
sex tinyint NOT NULL DEFAULT '0')

CREATE TABLENAME(
sex tinyint NOT NULL DEFAULT '0' COMMENT '0 1 2')

CREATE TABLE Dbname.Tablename (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
sex TINYINT UNSIGNED NOT NULL,
PRIMARY KEY (id)
)
ENGINE = InnoDB;

CREATE TABLE Dbname.Tablename (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
sex TINYINT UNSIGNED NOT NULL,
PRIMARY KEY (id)
)
ENGINE = InnoDB;