인턴일지
mysql 쿼리문
은찐찐
2019. 2. 28. 15:14
CREATE TABLE `user_table` (
`id` varchar(45) NOT NULL,
`password` varchar(45) NOT NULL,
`email` varchar(45) NOT NULL,
`first_name` varchar(45) NOT NULL,
`last_name` varchar(45) NOT NULL,
`position` varchar(45) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `email` (`email`)
)
INSERT INTO `project`.`user_table`
(`id`, `password`,`email`,`first_name`,`last_name`,`position`)
VALUES('master','master','master','master','master','master')