반응형
테이블 생성
-
02. 게시판 (테이블 생성)Spring Web Project/2. 게시판 (Board) 2020. 11. 24. 13:11
00. Select Database > use mysql; 01. Create Table create table tbl_board ( bno INT NOT NULL AUTO_INCREMENT, title VARCHAR(200) NOT NULL, content TEXT NULL, writer VARCHAR(50) NOT NULL, regdate TIMESTAMP NOT NULL DEFAULT now(), viewcnt INT DEFAULT 0, PRIMARY KEY (bno)); 02. Table 생성 확인 select * from tbl_board; 03. Insert data insert into tbl_board(title, content, writer) values ('제목', '내용', 'User..