11. JSP, DataBase (2) - Basic Query

create table member(
    id varchar(50) not null primary key,
    passwd varchar(16) not null,
    name varchar(10) not null,
    reg_date datetime not null
);

 

desc member;

내림차순 정렬

create table test(
    num_id int not null primary key auto_increment,
    title varchar(50) not null,
    content text not null
);

drop table test;

show tables;

insert into member(id, passwd, name, reg_date)
values('rylah@lycos.co.kr', '1234', '김김김', now());
 
insert into member(id, passwd, name, reg_date)
values('maiyo@aaa.com', '1111', '홍길동', now());

select * from member;

select id, passwd from member;

select id, passwd from member where id='rylah@lycos.co.kr';

update member set passwd='3579' where id='maiyo@aaa.com';
 
select * from member where id='maiyo@aaa.com';

delete from member where id='maiyo@aaa.com';
 
select * from member;

delete from member;
 
select * from member;