IT/SQL
MySql) Create table
2T1
2022. 11. 29. 18:12
|
1
2
3
4
5
6
7
8
|
CREATE TABLE `test`.`tb_emp` (
`NAME` VARCHAR(8) NOT NULL,
`BIRTH` VARCHAR(20) NOT NULL,
`PHONE_NO` VARCHAR(11) NOT NULL,
`TEL_NO` VARCHAR(10) NULL,
`ADDR1` VARCHAR(20) NOT NULL,
`ADDR2` VARCHAR(6) NULL,
PRIMARY KEY (`NAME`, `BIRTH`, `PHONE_NO`));
|
cs |