PHP?MySQL ??????

1
PHP?MySQL ??????
???? ?

• ? 22 ?
• SQL ?????MySQL???

2
22-1 ??? SQL?

• SQL??????????????????????????1970????,??SQL???????
  ???????IBM???(IBM Laboratory)?
• SQL (Structured Query Language)?
• ???????

3
22-1 ??? SQL?

• SQL ??? S-Q-L ? see-kwul?
• SQL??????,??ANSI(????????)?ISO(??????)?2??????????
  ??????????,??1986??ANSI???,?????1992??ANSI?ISO????
  ?????,???????SQL-92??,??SQL2????,ANSI?SIO?????????
  ????,????????SQL-99??,??SQL3????SQL???????SQL-92(S
  QL2)?

4
????

• ?????
• ??????
• ???(keyword)?
• ???
• ???

5
22-2 SQL ???????

• 22-2-1 DDL ??????
• CREATE
• ALTER
• DROP

6
22-2 SQL ???????

• 22-2-2 DML ??????
• SELECT
• INSERT
• UPDATE
• DELETE

7
22-2 SQL ???????

• 22-2-3 ??????
• GRANT
• REVOKE
• COMMIT
• ROLLBACK

8
22-3 ??????

• ??????
• ?????
• ????
• ?????
• ?????
• ??????

9
22-4 ?????

• 22-4-1 CREATE
• ??
• CREATE DATABASE ?????
• ?
• create database db_name
• Create DATABASE db_name
• CREATE DATABASE db_name

10
22-4 ?????

• 22-4-2 USE
• USE db_name
• 22-4-3 DROP
• DROP db_name

11
22-4 ?????

• 22-4-4 ?? Mysqladmin ???????
• ???????
• /mysql/bin/mysqladmin CREATE db_name
• ??????
• /mysql/bin/mysqladmin DROP db_name

12
22-5 ????????

• MySQL ?????????
• host
• user
• db

13
22-5 ????????
?
14
22-5 ????????

• ???????? host ???
• INSERT INTO host VALUES ('localhost','sample_db','
  Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')

15
22-5 ????????

• ????????? user ???
• INSERT INTO user VALUES ('localhost','testuser',PA
  SSWORD('password123'),'Y','Y','Y','Y','Y','Y','Y',
  'Y','Y','Y','Y','Y','Y','Y')

16
22-5 ????????

• ?????????????? db ???
• INSERT INTO db VALUES ('localhost','sample_db','te
  stuser','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')