kyun님의 이글루

1. MySQL 4.0 설치

2. 데이타 베이스 생성
c:\mysql\bin>mysqladmin -u root create TESTDB

3.계정 생성
mysql>grant select,insert,update,delete,create,drop on TESTDB.* to 'kyun'@'localhost' identified by '1234'

4.접속
c:\mysql\bin>mysql -u kyun -p TESTDB

//쿼리문

create table 테이블명(
컬럼명 VARCHAR(2) NOT NULL PRIMARY KEY,
...
)

insert into 테이블명(컬럼1,...) values ('값1'...);

select * from TABLE where ID = 'kyun' AND PASSWD <> "1234" AND E-MAIL is not NULL order by ID asc;
count(*),max(ID),min..,sum..

update TABLE set NAME = 'lkyunl where NAME = 'kyun';

delete from TABLE where NAME = 'lkyunl';

select A.필드1,A.필드2,B.필드3,B.필드4 from TABLE as A, TABLE2 as B
where A.필드 = B.필드

select * from MEMBER as A, MEMBER_ETC as B where A.MEMBERID = B.MEMBERID;