board.sql

[bitcocom]

- MySQL -
create table myboard(
	idx int not null auto_increment,
	title varchar(100) not null,
	content varchar(2000) not null,
	writer varchar(30) not null,
	indate datetime default now(),
	count int default 0,
	primary key(idx)
);

insert into myboard(title,content,writer)
values('게시판 연습','게시판 연습','관리자');

insert into myboard(title,content,writer)
values('게시판 연습','게시판 연습','박매일');

insert into myboard(title,content,writer)
values('게시판 연습','게시판 연습','선생님');

select * from myboard order by idx desc;

- Oracle -
create table myboard(
  idx number not null,
  title varchar2(100) not null,
  content varchar2(2000) not null,
  writer varchar2(30) not null,
  indate date default sysdate,
  count number default 0,
  primary key(idx)
);
create sequence myboard_idx;

insert into myboard(idx, title, content, writer)
values(myboard_idx.nextval, '스프링게시판','스프링게시판','관리자');

insert into myboard(idx, title, content, writer)
values(myboard_idx.nextval, '스프링게시판','스프링게시판','박매일');

select * from myboard order by idx desc;