α׷ HOME > θ > ǻ ü > α׷   
       

MySQL ǽ ͺ̽ ý

ǸŰ :   12,000
:   , ֳ,
ǻ :   21

  å 3η Ǿ ִ. δ ͺ̽ ̷п ϰ, δ MySQL ǽ , δ ڹپ ͺ̽ ý . ο ο θ ؼ н ̷а ǽ ִ ȰϿ ͺ̽ý ϴ Ʈ Ѵ. Ʈ ϴ ֺ ͺ̽ ν ͺ̽ý ȿ ɿ ٽ ִ ȸ ȮѴ.


1 ͺ̽ ̷

1. ͺ̽ý

1.1 ͺ̽

1.2 ͺ̽ý

1.3 ; Ͱ

2. ͺ̽ý

2.1 ͺ̽ý

2.2 ͺ̽ý

2.2.1 DZ

2.2.2 ۱

2.2.3

2.3

2.4 (data independency)

3. 赥ͺ̽

3.1 ͺ̽ý SDLC

3.2 ü-(Entity Relationship:E-R)

3.2.1 ü հ ƮƮ

3.2.2

3.3 E-R ̾׷

4. 赥

4.1 ̼

4.2 Ἲ

4.3

4.4 ؼ

5. л/Ƽ̵/ü ͺ̽ý

5.1 л ͺ̽ý

5.1.1 л ͺ̽

5.1.2 л ͺ̽ ý

5.1.3 л ͺ̽ ý

5.2 л 󼺰 ͺ

5.2.1 л ͺ̽

5.2.2 л ͺ̽

5.2.3 л ͺ̽ ܰ

5.3 Ƽ̵ ͺ̽ý

5.3.1 Ƽ̵ ͺ̽

5.3.2 Ƽ̵ ͺ̽ MDBMS

5.3.3 ü ͺ̽ Ƽ̵

5.4 ü ͺ̽ý

5.4.1 ü ͺ̽

5.4.2 ü ͺ̽

5.4.3 ü

  <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

2 MySQLǽ

6. ̺

6.1 ̺

7. MySQL ϱ

7.1 MySQL ġϱ

7.1.1 RPM Ű ؼ MySQL 74

7.1.2 tar.gz ̿ ġ

7.2 MySQL ϱ

7.3 MySQLɾ

7.3.1 Էϱ

7.3.2 ͺ̽

8. ̺ ϴ ɾ

8.1 ü MySQL ̺

8.2 vi ⸦ ̿ؼ ̺ ڵ ϱ

 

9. ̺ ϱ

9.1 ̺

9.2 UPDATE ϱ

9.3 ͸ ÷ ϱ

9.4 SET ÷ = ̺

9.5 ̺ ڵ带 ҷ ۾

9.6 ˻ ̺ ҷ ۾

9.6.1 WHERE ̿ ڷ ˻

9.7 ¥ Ͱ ó

9.8 DELETE ɾ

9.9 DELETE ɹ WHERE

10. ˻ ۾

10.1 ¥ Լ

10.2 ˻

10.3 Ī

10.3.1 ÷ ڵ ϴ ۾

10.3.2 ̻ ÷ ڵ ϴ ۾

10.3.3 DISTINCT ̿Ͽ ߺ ڵ ߷

10.3.4 GROUP BY ÷ ̿Ͽ ׷ ۾

11. ̺ ۾

11.1 ͸ ϴ ۾

11.2 ̺ ÷ κ ڷ

11.3 ̺ ÷ ü ڷ

11.4 Ʈ ̿ ̺ ˻ ۾

12. ̺ Ʈ ۾

12.1 DROP ɾ

12.2 UPDATE ɹ WHERE

12.3 ̺ ÷

12.3.1 ALTER TABLE ⺻

12.3.2 ALTER TABLE ÷ Ÿ

 

3 ͺ̽ ϴ ڹα׷ ϱ

1. Project

1.1 α׷ м

1.2 ߿ ޼

1.3 α׷

1.4

2.1 α׷ м

2.2 ߿ ޼

2.3 α׷


Copyright(c) 2003 TEL:(031)942-7861 FAX:(031)942-7864. All Rights Reserved. Send E-mail to webmaster