> For the complete documentation index, see [llms.txt](https://learnsql.gitbook.io/lernmysql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learnsql.gitbook.io/lernmysql/create-table-nhanvien.md).

# CREATE TABLE NHANVIEN

CREATE TABLE NHANVIEN(`HONV` VARCHAR(10) NOT NULL, `TENLOT` VARCHAR(10) NOT NULL, `TENNV` VARCHAR(10) NOT NULL, `MANV` CHAR(9) PRIMARY KEY, `NGAYSINH` DATETIME, `DCHI` VARCHAR(50), `PHAI`CHAR(3) CHECK (`PHAI` IN (`NAM`, `NU`)));