oracle sql
1. create table board(unq number(5) not null,title varchar2(30) not null,pwd varchar2(30) not null,writer varchar2(30) not null,content varchar2(200),hit number(5));rdate timestamp); 2. insert into board values('1','aaa','1234','aaa1','sodan','',sysdate); 3. select *from board order by rdate desc;4.select *from board where title like '%a2%' or content like '%a2%'; 5.select *from board where to_c..
2015. 9. 24.
sql create,concat,as,datediff,date_fomat,이중 select,if, 소개팅어플 db
@membership테이블 생성create table membsership(unq int unsigned not null auto_increment,user_id varchar(50) not null,user_pwd varchar(100) not null,user_name varchar(20) not null,gender enum('M','F'),birth char(8) not null,email varchar(100),tel varchar(20),hp varchar(20),post varchar(100),addr1 varchar(100),addr2 varchar(100),primary key(unq)); @memberOther테이블 생성create table memberOther(unq int unsi..
2015. 8. 12.