B / Y / U / S
HOME À¥ È£½ºÆà µµ¸ÞÀÎ ¸Å´º¾ó °í°´Áö¿ø ¼³Á¤Á¤º¸ °èÁ¤½Åû 2024-12-27 Friday 
À¥ È£½ºÆÃ
# °øÁö »çÇ×
# ÀÚÁÖ ¹¯´Â Áú¹®
# Áú¹®°ú ´äº¯
# °¡ÀÔ ¹®ÀÇ
Ä¿¹Â´ÏƼ
# ÀÚÀ¯°Ô½ÃÆÇ
# ¸®´ª½ºÆÁ
# ¾ÆÀÌÅ¥ Å×½ºÆ®
# ³»È¨ ¼Ò°³
# °Ö·¯¸®
# ÀÚ·á½Ç

  ¸®´ª½ºÆÁ  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 ==> ÇöÀç ¼³Ä¡µÇ¾î ÀÖ´Â Å×À̺íµéÀ» º¸¿©ÁØ´Ù.
Regist Addr [ 211.249.191.6 ] ¸ñ·Ïº¸±â À­±Û ¾Æ·§±Û
Á¤±ÔÇ¥Çö½Ä [ »ó¼¼ °Ë»ö ]
Page Loading [ 0.02 Sec ] SQL Time [ 0 Sec ]

Copyleft 1999-2024 by JSBoard Open Project
Theme Designed by IDOO And follow GPL2

°³ÀÎÁ¤º¸ Ãë±Þ¹æħ ÀÌ¿ë ¾à°ü »çÀÌÆ® ¸Ê ¾îµå¹Î °ü¸®