본문 바로가기
728x90
반응형

이중 select3

mysql,if,ifnull, format, update,이중 select membership필드종류Collation보기Null기본값추가실행unqint(10)UNSIGNED아니오auto_incrementuser_idvarchar(20)euckr_korean_ci아니오user_pwdvarchar(100)euckr_korean_ci아니오user_namevarchar(20)euckr_korean_ci아니오genderenum('M', 'F')euckr_korean_ci예NULLbirthdate예NULLemailvarchar(100)euckr_korean_ci예NULLtelvarchar(20)euckr_korean_ci예NULLhpvarchar(20)euckr_korean_ci아니오postchar(6)euckr_korean_ci예NULLaddr1varchar(100)euckr_korea.. 2015. 8. 17.
mysql as,update,desc,asc,is null,or,concat,like,이중 select membership 필드종류Collation보기Null기본값추가실행unqint(10)UNSIGNED아니오auto_incrementuser_idvarchar(20)euckr_korean_ci아니오user_pwdvarchar(100)euckr_korean_ci아니오user_namevarchar(20)euckr_korean_ci아니오genderenum('M', 'F')euckr_korean_ci예NULLbirthdate예NULLemailvarchar(100)euckr_korean_ci예NULLtelvarchar(20)euckr_korean_ci예NULLhpvarchar(20)euckr_korean_ci아니오postchar(6)euckr_korean_ci예NULLaddr1varchar(100)euckr_kore.. 2015. 8. 14.
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.
728x90
반응형