ȸ¿ø°¡ÀԡžÆÀ̵ð/ºñ¹øÃ£±â
ȨÀ¸·Î


SQL Äõ¸® Á¤¸®
9³â Àü
SELECT

SELECT * FROM Å×À̺í¸í WHERE Çʵå='Á¶°Ç' AND Çʵå2='Á¶°Ç2'
SELECT Çʵå1, Çʵå2, Çʵå3 FROM Å×À̺í¸í
SELECT * FROM TAB; Á¸ÀçÇÏ´Â ¸ðµç Å×ÀÌºí º¸±â
SELECT DISTINCT Çʵå1 FROM Å×À̺í¸í; Áߺ¹Á¦°ÅÇϱâ
SELECT Çʵå1 FROM Å×À̺í WHERE Çʵå2 BETWEEN 00 AND 00; //00ºÎÅÍ 00»çÀÌ¿¡¼­
SELECT Çʵå1 FROM Å×À̺í WHERE Çʵå2 IN (00, 00); //00°ú 00Áß¿¡¼­
SELECT Çʵå1 FROM Å×À̺í WHERE Çʵå2 LIKE '%´Ü¾î%';
SELECT Çʵå1 FROM Å×À̺í WHERE Çʵå2 IS NULL; or NoT IS NULL


UPDATE

UPDATE Å×À̺í¸í SET Çʵå='°ª', Çʵå2='°ª', Çʵå3='°ª' WHERE Çʵå LIKE 'Á¶°Ç'

INSERT

INSERT INTO Å×À̺í¸í(Çʵå1, Çʵå2) VALUES ('°ª', '°ª' );

ºñ±³¿¬»êÀÚ : >, >=, <, <=, =, <>(not equal)

DROP TABLE Å×À̺í¸í;

CREATE TABLE Å×À̺í¸í (
      Çʵå¸í ŸÀÔ Á¶°Ç,
      id varchar2(15) primary key,
      pass varchar(15) not null,
      no number(5)
)

½ÃÄö½º »ý¼º : CREATE SEQUENCE ½ÃÄö½ºÀ̸§
                   increment by 1
                   start with 1
                   nomaxvalue
                   nocycle
                   nocache;

¿Ü·¡Å° »ý¼º : ALTER TABLE Å×À̺í¸í ADD ( FOREIGN KEY (Çʵå) REFERENCES Å×À̺í¸í2);

Ä®·³ ¼öÁ¤ : ALTER TABLE Å×À̺í¸í MODIFY (Çʵå ŸÀÔ);

Ä÷³ Ãß°¡ : ALTER TABLE Å×À̺í¸í ADD ( ÇʵåÀ̸§ ÇʵåŸÀÔ );

Ä®·³ ¸®³×ÀÓ : ALTER TABLE Å×À̺í¸í RENAME COLUMN Ä÷³À̸§ TO »õÀ̸§;

Null°ª ó¸®Çϱâ : SELECT isNULL(Çʵå, '0') FROM Å×À̺í

¹æ±Ý Àμ­Æ®ÇÑ ÀÚµ¿Áõ°¡°ª ID °¡Á®¿À±â : SELECT @@IDENTITY (ÇöÀç ¼¼¼Ç¿¡¼­¸¸ »ç¿ë°¡´É)
ÇöÀç Å×À̺íÀÇ °¡ÀåÅ« ūū°ª °¡Á®¿À±â : SELECT IDENT_CURRENT('Å×À̺í¸í')
¼öÇàµÈ SQL¹®¿¡ ÀÇÇØ ¿µÇâ¹ÞÀº ÇàÀÇ ¼ö : SELECT @@ROWCOUNT

³¯Â¥ °è»êÇϱâ : SELECT * FROM Å×À̺í¸í WHERE DATEADD(DAY, CONVERT(INT, Ä÷³¸í), ³¯Â¥Ä÷³) > getdate()

Å×À̺í Á¤º¸º¸±â : EXEC sp_help Å×À̺í
Ä÷³ Á¤º¸º¸±â : EXEC sp_columns Å×À̺í

¾Ù¸®¾î½º »ç¿ë : SELECT Çʵå AS A FROM Å×À̺í (º°Äª¿¡ Ư¼ö¹®ÀÚ ÀÖÀ¸¸é [] »ç¿ë]

ÁÖ¼® : -- or /* */

º¯¼öÀÇ ¼±¾ð : DECLARE @º¯¼ö¸í ÀÚ·áÇü, @º¯¼ö¸í ÀÚ·áÇü
º¯¼ö ÇÒ´ç : SET @º¯¼ö¸í = °ª
º¯¼ö°ª °¡Á®¿À±â : SELECT @º¯¼ö¸í

ÀϺκи¸ °¡Á®¿À±â : SELETC TOP 5 Ä÷³ FROM Å×À̺í

¹üÀ§Á¤Çϱâ SELECT Ä÷³ FROM Å×À̺í WHERE Ä÷³ BETWEEN 10 AND 20
                SELECT Ä÷³ FROM Å×À̺í WHERE Ä÷³ IN ('aaa', 'bbb', 'ccc')

ÆÐÅϸÅĪ : SELECT Ä÷³ FROM Å×À̺í WHERE Ä÷³ LIKE '%Á¦¸ñ%"
               _ : ¾î¶²°ÍÀ̵ç ÇÑ ¹®ÀÚ
               % : ¾ø°Å³ª ¾Æ¹« ±ÛÀÚ¿À°Å³ª
               [] : []¾È¿¡ ÀÖ´Â ±ÛÀÚµé - [b-f]
               [^] : ^´Ù¸§¿¡ ÀÖ´Â ±ÛÀÚ¸¦ Á¦¿ÜÇÑ ´Ù¸¥ °Í

Áߺ¹Á¦°Å : SELECT DISTINCT Ä÷³ FROM Å×À̺í

GROUP BY : SELECT Ä÷³1, sum(Ä÷³2) FROM Å×À̺í WHERE Á¶°Ç GROUP BY Ä÷³1 HAVING sum(Ä÷³2) >= 30
(°è»êÇÔ¼ö°¡ ¹Ýµå½Ã ÀÖ¾î¾ß ÇÑ´Ù, GROUP BY ALLÀ» »ç¿ëÇϸé WHEREÁ¦¿ÜµÈ°Í µµ Æ÷ÇÔ)

À̳ÊÁ¶ÀÎ : SELECT Ä÷³ FROM Å×À̺í INNER JOIN Å×À̺í ON Ä÷³=Ä÷³
¾Æ¿ôÅÍÁ¶ÀÎ : SELECT Ä÷³ FROM Å×À̺í LEFT OUTER JOIN Å×À̺í ON Ä÷³=Ä÷³
                  (¾î´ÀÇÑÂÊÀÇ µ¥ÀÌÅ͸¦ ¸ðµÎ °¡Á®¿Â´Ù.)

IN : SELECT Ä÷³ FROM Å×À̺í WHERE Ä÷³2 IN ( SELECT Ä÷³2 FROM Å×À̺í )
     (IN¾ÈÀÇ ÇÏÀ§ÁúÀÇ´Â DISTINCT°¡ ºÙÀº °ÍÀ¸·Î µ¿ÀÛ)
EXISTS : SELECT Ä÷³1 FROM Å×ÀÌºí  WHERE EXISTS ( SELECT * FROM Å×À̺í WHERE Á¶°Ç )
              (EXISTS´Â ÇÏÀ§Äõ¸®°¡ ¾î¶² °á°ú¶óµµ µ¹·ÁÁö¸é Âü)

ÀÓ½ÃÅ×ÀÌºí ¸¸µé±â : SELECT INTO SELECT * INTO »õÅ×À̺í¸í FROM Å×À̺í (´Ù¸¥¼¼¼Ç¿¡¼­µµ °¡´É, DROPÇØ¾ß »èÁ¦µÊ)
                            SELECT INTO SELECT * INTO #»õÅ×À̺í¸í FROM Å×À̺í (ÇØ´ç¼¼¼Ç¿¡¼­¸¸ °¡´É, ¼¼¼Ç²÷¾îÁö¸é »èÁ¦µÊ)
                            SELECT INTO SELECT * INTO ##»õÅ×À̺í¸í FROM Å×À̺í (´Ù¸¥¼¼¼Ç¿¡¼­µµ °¡´É, ¼¼¼Ç²÷¾îÁö¸é »èÁ¦µÊ)

UNION : SELECT Ä÷³1, Ä÷³2 FROM Å×À̺í
            UNION
            SELECT Ä÷³1, Ä÷³2 FROM Å×À̺í
            (UNIONÀº Ä÷³ÀÇ ÀÚ·áÇü°ú ¼ø¼­°¡ ¸Â¾Æ¾ß ÇÑ´Ù. Áߺ¹µ¥ÀÌÅÍ´Â Á¦°ÅµÇ¸ç UNION ALLÀ» Çϸé Áߺ¹µ¥ÀÌÅ͵µ °¡Á®¿Â´Ù.)

Ä÷³ Ãß°¡ : ALTER TABLE Å×À̺í¸í ADD »õÄ÷³ VARCHAR(10) NULL
Ä÷³ º¯°æ : ALTER TABLE Å×À̺í¸í ALTER COLUMN Ä÷³ VARCHAR(10) NULL
Ä÷³ »èÁ¦ : ALTER TABLE Å×ÀÌºíº´ DROP COLUMN Ä÷³

»èÁ¦ : DELETE FROM Å×À̺í¸í WHERE Á¶°Ç

¾÷µ¥ÀÌÆ® : UPDATE Å×À̺í SET Ä÷³ = °ª WHRER Á¶°Ç

Æ®·£Àè¼Ç : BEGIN TRAN
               ROLLBACK
               COMMIT




µ¡) SELECT¿¡ ¿Ø¸¸Çϸé * ´Â »ç¿ëÇÏÁö ¾Ê´Â´Ù.

µ¡) WHEREÀý¿¡¼­ ¿¬»êÀÚÀÇ ¿ÞÂÊÀº °¡µ¿ÇÏÁö ¾Ê´Â´Ù. Ä÷³À» °¡°øÇÏ¸é »öÀÎÀ» »ç¿ëÇÒ ¼ö ¾ø´Ù.
        WHERE Ä÷³ * 3 < 10 ¸»°í WHERE Ä÷³ < 10 / 3 À» »ç¿ëÇÏÀÚ
ÃßõÃßõ : 547 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
2,651
ÀÚ¹Ù½ºÅ©¸³Æ® Base64 encode, decode
2,650
PHP ¹®ÀÚ¿­ °ü·Ã ÇÔ¼ö
2,649
[php] ¹®ÀÚ¿­À» ³ª´©°Å³ª ÇÕÄ¡´Â explode, implode ÇÔ¼ö
2,648
php ¹®ÀÚ¿­ ÀÚ¸£±â ³ª´©±â ºÐ¸®Çϱâ - explode() , split()
2,647
DB Á¢±Ù ¹× Äõ¸®¹®(insert,select,update,delete)
2,646
[MySQL] Çʵ忡¼­ ƯÁ¤¹®ÀÚ Æ÷ÇÔ ¶Ç´Â Á¦¿ÜÇÑ DB °Ë»ö, LIKE ,NOT
2,645
php5 mysqli µðºñ Á¢¼Ó Ŭ·¡½º ÇÁ·Î±×·¥ ¹× »ç¿ë¹ý
2,644
PHP ¹®ÀÚ¿­ ³ª´©±â - explode()
2,643
[PHP] ¹è¿­ Array
2,642
php ¹è¿­
2,641
[php] Array() ¹è¿­À̶õ?
2,640
PHP ¹è¿­ ÇÔ¼ö Á¤¸®
2,639
PHP ±âº»ÀûÀÎ ¹è¿­ »ç¿ë¹ý
2,638
html¿¡¼­ ÀÔ·ÂÇѰª DB¿¡¼­ ¹Þ¾Æ¿À±â (µµ¼­Á¤º¸ °Ë»ö)
SQL Äõ¸® Á¤¸®
2,636
[MySql]DB¿¡¼­ ¼­·Î ´Ù¸¥ Å×À̺íÀÇ µ¥ÀÌÅ͸¦ Çѹø¿¡ ºÒ·¯¿À±â
2,635
jquery checkbox Àüü ¼±ÅÃ, Àüü ÇØÁ¦, üũ °ª ÃßÃâ
2,634
php set time limit ÇÔ¼ö - ŸÀӾƿô ¼³Á¤
2,633
Setting .htaccess to allow PHP to be accessed with .xml extension
2,632
jQuery API: Manipulation, Events, Effects, Internals, Utilities
2,631
´Ù¿î·Îµå Ƚ¼ö Á¦ÇÑ ½ºÅ©¸³Æ®
2,630
ÀÚ¹Ù½ºÅ©¸³Æ® ŸÀÌ¸Ó - setTimeout, setInterval, clearInterval ÇÔ¼ö
2,629
jQuery AJAX ·Î±×ÀÎ ±¸Çö
2,628
PHP ¼¼¼Ç ·Î±×ÀÎ ±¸Çö
2,627
PHP ÄíŰ ·Î±×ÀÎ ±¸Çö
2,626
jQuery¿¡¼­ json º¯¼ö »ç¿ë(Ȱ¿ë)¹ý
2,625
AJAX ¹Ýº¹Ã³¸® ¹× ¼³¸í ¿¹Á¦
2,624
[Android] Intent Ȱ¿ë ¿¹½Ã
2,623
[php] ¹è¿­À» ÀÓÀÇÀÇ ¼ø¼­·Î ¼¯´Â shuffle ÇÔ¼ö
2,622
jQuery API - ¼Ó¼º(CSS), ÃßÃâ
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æÄ§
Copyright ¨Ï musictrot All rights reserved.