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.
mysql as, order by,where/sum,avg,min,max
create table student ( user_id varchar(50) not null, user_name char(50) not null, age tinyint default '0', gender enum('M','F'), year enum('1','2','3'), hakjum char(1)); hakjum 컬럼 삭제 alter table student drop hakjum; 다음 데이터 입력 user_id user_name age gender year a1 Tom 15 M 2 a2 Jane 16 F 3 a3 Yakima 14 M 1 a4 Yong 14 Null 1 a5 Minyo 0 F Null a6 Kang 15 Null 2 a7 Kim 0 M Null a8 Miranda 15 F 2 inse..
2015. 8. 5.