|
|
|
¸®´ª½ºÆÁ Go Unix Power Tools Online Book
Go Bash Guide
|
|
Read No. 120 article |
2002-03-06 09:32:19 |
|
|
|
|
NickName |
simon |
Subject |
Ç¥ÁØ SQL ¹®¹ý |
|
|
SQL(Structared Query Language)
Ç¥ÁØ SQL±Ô¾àÀ» µû¸£´Â DB¼¹ö¿¡ ÁúÀǸ¦ÇÏ´Â ¾à¼ÓµÈ ¹®¹ý
Ư¡
µ¥ÀÌŸ Á¶ÀÛ¾ð¾î(Data Manupulation Language)
. ÀÚ·á Á¶È¸ (SELECT)
. ÀÚ·á ¼öÁ¤ (UPDATE)
. ÀÚ·á »èÁ¦ (DELETE)
. ÀÚ·á ÀÔ·Â (INSERT)
- µ¥ÀÌÅÍ Á¤ÀÇ ¾ð¾î (Data Definition Language)
. Å×ÀÌºí »ý¼º (CREATE)
. Å×ÀÌºí »èÁ¦ (DROP)
. µ¥ÀÌºí¿¡ Ç׸ñ Ãß°¡ (ALTER)
- µ¥ÀÌÅÍ Á¦¾î ¾ð¾î (Data Control Language)
. ±ÇÇѺο© (GRANT)
. ±ÇÇÑÇØÁ¦ (REVOKE)
Á¶È¸ : select [Çʵå¸í] from [Å×À̺í¸í]
Ãß°¡ : insert into [Å×À̺í¸í]
»èÁ¦ : delete from [Å×À̺í¸í] WHERE [Á¶°Ç]
¼öÁ¤ : update [Å×À̺í¸í] set [Çʵå¸í]=[°ª] where [Á¶°Ç]
·¹ÄÚµå Ãß°¡ : insert into Å×À̺í_À̸§ VALUES(µ¥ÀÌŸ °ª...)
DB Handling
create database kamppo ==>kamppo ¶ó´Â µ¥ÀÌŸº£À̽º »ý¼º
create table jinro ==> jinro ¶ó´Â Å×ÀÌºí »ý¼º
use kamppo(database_name) ==> kamppo¶ó´Â µ¥ÀÌŸº£À̽º¿¡ ¿¬°á
drop kamppo ==> kamppo¶ó´Â µ¥ÀÌŸº£À̽º »èÁ¦
show databases ==> ÇöÀç ¼³Ä¡µÇ¾î ÀÖ´Â µ¥ÀÌŸ º£À̽ºµéÀ» º¸¿©ÁØ´Ù.
show tables ==> ÇöÀç ¼³Ä¡µÇ¾î ÀÖ´Â Å×À̺íµéÀ» º¸¿©ÁØ´Ù.
|
|
Page Loading [ 0.03 Sec ]
SQL Time [ 0.01 Sec ]
|
|
|