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')
'인턴일지' 카테고리의 다른 글
검색창 (0) | 2019.03.18 |
---|---|
회원가입 및 로그인 (0) | 2019.03.04 |
php (0) | 2019.02.21 |
MySQL - PHP (0) | 2019.02.21 |
mariaDB (0) | 2019.02.20 |