wf2L10Xs

1CREATE DATABASE `a2`;
2
3USE `a2`;
4
5DROP TABLE IF EXISTS `article`;
6
7CREATE TABLE `article` (
8  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
9  `regDate` datetime NOT NULL DEFAULT current_timestamp(),
10  `title` char(100) NOT NULL,
11  `body` text NOT NULL,
12  `memberId` int(10) unsigned NOT NULL,
13  `boardId` int(10) unsigned NOT NULL,
14  PRIMARY KEY (`id`)
15);
16
17insert  into `article`(`id`,`regDate`,`title`,`body`,`memberId`,`boardId`) values
18(1,'2019-07-26 13:30:16','제목1','내용1\nㅎㅎ',1,1),
19(2,'2019-07-26 13:30:16','제목2','내용2\nㅋㅋ',2,1),
20(3,'2019-07-26 13:30:16','제목3','내용3\nㅋㅋ',2,2),
21(4,'2019-07-26 13:30:16','제목1','내용1\nㅎㅎ',1,1),
22(5,'2019-07-26 13:30:16','제목2','내용2\nㅋㅋ',2,1),
23(6,'2019-07-26 13:30:16','제목3','내용3\nㅋㅋ',2,2),
24(7,'2019-07-26 13:30:16','제목1','내용1\nㅎㅎ',1,1),
25(8,'2019-07-26 13:30:16','제목2','내용2\nㅋㅋ',2,1),
26(9,'2019-07-26 13:30:16','제목3','내용3\nㅋㅋ',2,2),
27(10,'2019-07-26 13:30:16','제목1','내용1\nㅎㅎ',1,1),
28(11,'2019-07-26 13:30:16','제목2','내용2\nㅋㅋ',2,1),
29(12,'2019-07-26 13:30:16','제목3','내용3\nㅋㅋ',2,2),
30(13,'2019-07-26 13:30:16','제목1','내용1\nㅎㅎ',1,1),
31(14,'2019-07-26 13:30:16','제목2','내용2\nㅋㅋ',2,1),
32(15,'2019-07-26 13:30:16','제목3','내용3\nㅋㅋ',2,2);