Skip navigation
³»¿ë¾ø½¿
¹Ù·Î°¡±âÆíÁý
ÀÚÀ¯°Ô½ÃÆÇ
ÇÑÁÙ
QnA
Job
Life
¾÷üȫº¸
DIY
¾ð¹Ú½Ì
NAS
µö·¯´×
°¡»óÈ
Çϵå¿þ¾î
³×Æ®¿÷
RAID
°ÁÂ
ÀÚ·á
BMT
ÈÆÈÆ
ÆǸÅ
±¸¸Å
°ßÀû
ÇØ¿Ü
Ãâ¼®
¹Ù·Î
¹Ù·Î°¡±âÆíÁý
member_id
password
Auto
Login
ȸ¿ø°¡ÀÔ
¾ÆÀ̵ðã±â
UnBoxing
more
¼öÆÛ»çÀ̾ð´Ô Á¤¼ö¡¦
(1)
½É»ç¼÷°í´Ô Ä«ºñ´Ï¡¦
[¹«ºÐÁ÷¼ö·É] ¼úÀÌ¡¦
(2)
[¹«ºÐ¼ö·É] ½ºÄ«ÀÌ¡¦
[¹«ºÐ¼ö·É] 'gmltj¡¦
(1)
[¹«ºÐ¼ö·É] Â÷³ÝÄÄ¡¦
¸ñ·Ï
¾²±â
¸ñ·Ï
mysql Áú¹®ÀÔ´Ï´Ù..
Dian
2009-02
2009-02-17 13:22:18
Á¶È¸ 5398 Ãßõ 0
Çϵå¿þ¾î Ä¿¹Â´ÏƼÁö¸¸ ¼¹ö °ü¸®ÂÊ¿¡ ÀÏÇϽô ºÐÀÌ ¸¹À¸½Å°Í °°¾Æ¼ sql Áú¹®À» ¿Ã¸³´Ï´Ù.
ƯÁ¤ ¿¿¡ ÀÖ´Â µ¥ÀÌŸ¸¸ º¯°æÇÏ´Â sql ÁúÀǹ®À» Àß ¸ð¸£°Ú½À´Ï´Ù..
A¶õ µ¥ÀÌŸº£À̽º¿¡
mail À̶ó´Â Å×À̺íÀÌ ÀÖ½À´Ï´Ù.
±× ¾È¿¡ id ¶ó´Â ÁÙÀÇ µ¥ÀÌŸ¸¸ ÀÏÁ¤ °ªÀ¸·Î º¯°æ ȤÀº »èÁ¦ ÇÏ·Á¸é
sql ÁúÀǸ¦ ¾î¶»°Ô ÇØ¾ß Çϳª¿ä?
ªÀº±Û Àϼö·Ï ½ÅÁßÇÏ°Ô.
À̹®Èì
2009-02
update mail set id = [¾î¶²°ª] where id ¿¬»êÀÚ ¾î¶²°ªÀ̳ªÁ¶°Ç¹®
À¸·Î º¯°æÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù. where Àý Æ÷ÇÔÇؼ ±â¼úÇÏÁö ¾ÊÀ¸½Ã¸é id°¡ ÀüºÎ º¯°æµË´Ï´Ù.
[¾î¶²°ª]¿¡ ¿øÇϽô id °ªÀ» ÀÔ·ÂÇÒ ¼ö ÀÖ½À´Ï´Ù.
UPDATE [LOW_PRIORITY] [IGNORE] table_reference
SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
¾÷µ¥ÀÌÆ®(º¯°æ)ÇϽÃÀü¿¡ º¹¿ø ¹æ¹ýÀ̳ª ¹é¾÷ÀÇ Çʿ伺ÀÌ ÀÖ´ÂÁö ÆÇ´ÜÇϼ¼¿ä.
http://dev.mysql.com/doc/refman/5.0/en/update.html
update mail set id = [¾î¶²°ª] where id ¿¬»êÀÚ ¾î¶²°ªÀ̳ªÁ¶°Ç¹® À¸·Î º¯°æÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù. where Àý Æ÷ÇÔÇؼ ±â¼úÇÏÁö ¾ÊÀ¸½Ã¸é id°¡ ÀüºÎ º¯°æµË´Ï´Ù. [¾î¶²°ª]¿¡ ¿øÇϽô id °ªÀ» ÀÔ·ÂÇÒ ¼ö ÀÖ½À´Ï´Ù. UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ... [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] ¾÷µ¥ÀÌÆ®(º¯°æ)ÇϽÃÀü¿¡ º¹¿ø ¹æ¹ýÀ̳ª ¹é¾÷ÀÇ Çʿ伺ÀÌ ÀÖ´ÂÁö ÆÇ´ÜÇϼ¼¿ä. http://dev.mysql.com/doc/refman/5.0/en/update.html
¾î¸°¿ÕÀÚ
2009-02
À§ÀÇ ±×¸²À¸·Î ÃßÃø Çϱâ·Î´Â id °¡ PK
(row¸¦ ±¸ºÐÇÏ´Â ±¸ºÐ°ª)
·Î º¸À̴µ¥ ±×·¯¸é ÀÏÁ¤ÇÑ °ª(¸ðµÎ µ¿ÀÏÇÑ °ª)À¸·Î º¯°æÀÌ ºÒ°¡´É ÇÕ´Ï´Ù.
À§ÀÇ ±×¸²À¸·Î ÃßÃø Çϱâ·Î´Â id °¡ PK (row¸¦ ±¸ºÐÇÏ´Â ±¸ºÐ°ª) ·Î º¸À̴µ¥ ±×·¯¸é ÀÏÁ¤ÇÑ °ª(¸ðµÎ µ¿ÀÏÇÑ °ª)À¸·Î º¯°æÀÌ ºÒ°¡´É ÇÕ´Ï´Ù.
àØéÍз
2009-02
ƯÁ¤ Å×À̺íÀÇ Ä÷³À» »èÁ¦ÇÏ·Á¸é,
- Á¦¾àÁ¶°Ç »èÁ¦ÈÄ
alter table Å×À̺í¸í drop Ä÷³
alter table mail drop id
ƯÁ¤ Å×À̺íÀÇ Ä÷³À» »èÁ¦ÇÏ·Á¸é, - Á¦¾àÁ¶°Ç »èÁ¦ÈÄ alter table Å×À̺í¸í drop Ä÷³ alter table mail drop id
°û³ë¼º
2009-02
°¨»çÇÕ´Ï´Ù..
°¨»çÇÕ´Ï´Ù..
·Î±×ÀÎ ÇÏ½Ã¸é ´ñ±ÛÀ» ³²±æ ¼ö ÀÖ½À´Ï´Ù
¸ñ·Ï
¾²±â
¸ñ·Ï
QnA
¾²±â
4087/5613
¹øÈ£
Á¦¸ñ
Page 4087/5613
±Û¾´ÀÌ
³¯Â¥
Á¶È¸
̵̧
[Çʵ¶] óÀ½ ¿À½Ã´Â ºÐÀ» À§ÇÑ ¾È³»
(719)
Á¤ÀºÁØ1
2014-05
4597510
0
[Çʵ¶] óÀ½ ¿À½Ã´Â ºÐÀ» À§ÇÑ ¾È³»
(719)
2014-05 4597510
1
Á¤ÀºÁØ1
(±¤°í) ´ÜÅë¹ý ½Ã´ëÀÇ ÀÎÅͳݰ¡ÀÔ °¡À̵å(ver2.0)
(228)
¹é¸Þ°¡
2015-12
1145944
25
(±¤°í) ´ÜÅë¹ý ½Ã´ëÀÇ ÀÎÅͳݰ¡ÀÔ °¡À̵å(¡¦
(228)
2015-12 1145944
1
¹é¸Þ°¡
30530
¾ÆÆÄÆ® ·£¼± ²È´Â º®¸é ¼ÒÄÏ(?)ÀÌ °íÁ¤ÀÌ Àß ¾ÈµÇ³×¿ä. ¾î¶»°Ô ¼ö¸®ÇؾßÇϳª¿ä?
(1)
Çϼö¾ð
2009-03
8717
0
¾ÆÆÄÆ® ·£¼± ²È´Â º®¸é ¼ÒÄÏ(?)ÀÌ °íÁ¤ÀÌ ¡¦
(1)
2009-03 8717
1
Çϼö¾ð
30529
À߸¸»çÀÇ ¿Àüµµ Á¢Âøü »ç¿ë¹ý
(3)
ÀÌÁø¼ö
2009-03
6010
0
À߸¸»çÀÇ ¿Àüµµ Á¢Âøü »ç¿ë¹ý
(3)
2009-03 6010
1
ÀÌÁø¼ö
30528
À¯Áöºñ Àú·ÅÇÑ ÇÁ¸°ÅÍ Ãßõ ÇØÁÖ¼¼¿ä.
(6)
ÃÖ¸¶·ç
2009-03
7234
0
À¯Áöºñ Àú·ÅÇÑ ÇÁ¸°ÅÍ Ãßõ ÇØÁÖ¼¼¿ä.
(6)
2009-03 7234
1
ÃÖ¸¶·ç
30527
ATI ÀÓÀÇÀÇ Çػ󵵸¦ ¾î¶»°Ô ¸ÂÃߴ°ǰ¡¿ä?
(2)
ÃÖ¿ø½ÃÀÍ
2009-03
8076
0
ATI ÀÓÀÇÀÇ Çػ󵵸¦ ¾î¶»°Ô ¸ÂÃߴ°ǰ¡¿ä?
(2)
2009-03 8076
1
ÃÖ¿ø½ÃÀÍ
30526
raid 5¿Í 6ÀÇ ½ÇÁ¦ ¼Óµµ´Â ¾î´ÀÁ¤µµ µÇ´ÂÁö¿ä????
(4)
¼Û½Âȯ
2009-03
6358
0
raid 5¿Í 6ÀÇ ½ÇÁ¦ ¼Óµµ´Â ¾î´ÀÁ¤µµ µÇ´Â¡¦
(4)
2009-03 6358
1
¼Û½Âȯ
30525
Tayn s2498º¸µå(K7m Tomcat , Geode Àü¿ëº¸µå)¿¡ ´ëÇÑ Áú¹®ÀÔ´Ï´Ù.
(2)
±èÁöȯ1
2009-03
5048
0
Tayn s2498º¸µå(K7m Tomcat , Geode Àü¿ë¡¦
(2)
2009-03 5048
1
±èÁöȯ1
30524
Ȳµ¿ ±Ý¼Ó Ãд븦 Á¦ÀÛ(¼¼°ø)ÇÏ°í ½ÍÀºµ¥ ¹æ¹ýÀ̳ª ¾÷ü¸¦ ¾Ë·ÁÁÖ¼¼¿ä
(2)
¹Î»çÀå
2009-03
6069
0
Ȳµ¿ ±Ý¼Ó Ãд븦 Á¦ÀÛ(¼¼°ø)ÇÏ°í ½ÍÀºµ¥ ¡¦
(2)
2009-03 6069
1
¹Î»çÀå
30523
SCSI ÀνĹ®Á¦
(7)
½ÅÇö¸ð
2009-03
9380
0
SCSI ÀνĹ®Á¦
(7)
2009-03 9380
1
½ÅÇö¸ð
30522
USB, µðÄ«¸Þ¸ð¸® µå¶óÀ̺ê¸í º¯°æ ¹æ¹ýÀÌ ±Ã±ÝÇÕ´Ï´Ù
(2)
¼öÆÛ¸Ç1
2009-03
6048
0
USB, µðÄ«¸Þ¸ð¸® µå¶óÀ̺ê¸í º¯°æ ¹æ¹ýÀÌ ¡¦
(2)
2009-03 6048
1
¼öÆÛ¸Ç1
30521
Çϵ尡 °©ÀÚ±â RAW·Î ÀνÄÇÕ´Ï´Ù. º¹±¸ ¹æ¹ý Á» ¾Ë·ÁÁÖ¼¼¿ä.
(4)
±èâÀ±(WC)
2009-03
7545
0
Çϵ尡 °©ÀÚ±â RAW·Î ÀνÄÇÕ´Ï´Ù. º¹±¸ ¹æ¡¦
(4)
2009-03 7545
1
±èâÀ±(WC)
30520
±¹³»¿¡¼ Åø(µ¥ÀÌŸº¹±¸)±¸ÇÒ¼ö ÀÖ³ª¿ä
(2)
¿©ÁÖÀÌ»óµ·
2009-03
12410
0
±¹³»¿¡¼ Åø(µ¥ÀÌŸº¹±¸)±¸ÇÒ¼ö ÀÖ³ª¿ä
(2)
2009-03 12410
1
¿©ÁÖÀÌ»óµ·
30519
(Æäµµ¶ó10) ¼³Ä¡½Ã 40GÇϵå1 + Raid0(20GX4)·Î ¼³Ä¡Çߴµ¥...Raid0ºÎºÐÀ» AccessÇÏ·Á¡¦
(7)
±è°Ç¿ì
2009-03
7413
0
(Æäµµ¶ó10) ¼³Ä¡½Ã 40GÇϵå1 + Raid0(20GX¡¦
(7)
2009-03 7413
1
±è°Ç¿ì
30518
ÁÁÀº ÇǺΰú¸¦ ã½À´Ï´Ù.
(6)
½É¹ÙÆ®
2009-03
9289
0
ÁÁÀº ÇǺΰú¸¦ ã½À´Ï´Ù.
(6)
2009-03 9289
1
½É¹ÙÆ®
30517
ÃÊ°í»ç¾ç ³ëÆ®ºÏ µµ´ëü ¾îµð¼ »ì¼ö ÀÖ½À´Ï±î?
(12)
Ǫ¸ªÀÌ
2009-03
7243
0
ÃÊ°í»ç¾ç ³ëÆ®ºÏ µµ´ëü ¾îµð¼ »ì¼ö ÀÖ½À¡¦
(12)
2009-03 7243
1
Ǫ¸ªÀÌ
30516
È÷Ÿġ Çϵ忡 ´ëÇؼ...
(4)
akfalles
2009-03
10811
0
È÷Ÿġ Çϵ忡 ´ëÇؼ...
(4)
2009-03 10811
1
akfalles
30515
Via694x º¸µå¿Í WOL
(2)
Sico
2009-03
7928
0
Via694x º¸µå¿Í WOL
(2)
2009-03 7928
1
Sico
30514
LCD Áß¿¡¼ ÄÄÆÛÁöÆ® ´ÜÀÚ(Yellow) ÀԷ°¡´ÉÇÑ 19" ±Þ Á¦Ç°ÀÌ ÀÖÀ»±î¿ä?
(3)
Á¤ÀºÁØ1
2009-03
5248
0
LCD Áß¿¡¼ ÄÄÆÛÁöÆ® ´ÜÀÚ(Yellow) ÀԷ°¡¡¦
(3)
2009-03 5248
1
Á¤ÀºÁØ1
30513
[±Þ] ¼Ö¸®µå¿÷½º 2009 ¼ÂÆÃ~!
ÀüÇö±Ô
2009-03
5113
0
[±Þ] ¼Ö¸®µå¿÷½º 2009 ¼ÂÆÃ~!
2009-03 5113
1
ÀüÇö±Ô
30512
SyQuset ¶ó´Â ȸ»çÀÇ ez230 µå¶óÀ̹ö ¿äûÀÔ´Ï´Ù..
(1)
ÇØÇÇ¿£Á©
2009-03
5387
0
SyQuset ¶ó´Â ȸ»çÀÇ ez230 µå¶óÀ̹ö ¿äû¡¦
(1)
2009-03 5387
1
ÇØÇÇ¿£Á©
30511
Windows ³×Æ®¿÷ ¿¬°á °ü·Ã ¹®Á¦
(4)
±è´ë¿Õ
2009-03
5605
0
Windows ³×Æ®¿÷ ¿¬°á °ü·Ã ¹®Á¦
(4)
2009-03 5605
1
±è´ë¿Õ
4081
4082
4083
4084
4085
4086
4087
(current)
4088
4089
4090
4086
4087
(current)
4088
4089
4090
¸ñ·Ï
¾²±â
sfl
Á¦¸ñ
³»¿ë
Á¦¸ñ+³»¿ë
ȸ¿ø¾ÆÀ̵ð
ȸ¿ø¾ÆÀ̵ð(ÄÚ)
À̸§
À̸§(ÄÚ)
stx
sop
and
or
°Ë»ö
À¸·Î º¯°æÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù. where Àý Æ÷ÇÔÇؼ ±â¼úÇÏÁö ¾ÊÀ¸½Ã¸é id°¡ ÀüºÎ º¯°æµË´Ï´Ù.
[¾î¶²°ª]¿¡ ¿øÇϽô id °ªÀ» ÀÔ·ÂÇÒ ¼ö ÀÖ½À´Ï´Ù.
UPDATE [LOW_PRIORITY] [IGNORE] table_reference
SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]
¾÷µ¥ÀÌÆ®(º¯°æ)ÇϽÃÀü¿¡ º¹¿ø ¹æ¹ýÀ̳ª ¹é¾÷ÀÇ Çʿ伺ÀÌ ÀÖ´ÂÁö ÆÇ´ÜÇϼ¼¿ä.
http://dev.mysql.com/doc/refman/5.0/en/update.html
(row¸¦ ±¸ºÐÇÏ´Â ±¸ºÐ°ª)
·Î º¸À̴µ¥ ±×·¯¸é ÀÏÁ¤ÇÑ °ª(¸ðµÎ µ¿ÀÏÇÑ °ª)À¸·Î º¯°æÀÌ ºÒ°¡´É ÇÕ´Ï´Ù.
- Á¦¾àÁ¶°Ç »èÁ¦ÈÄ
alter table Å×À̺í¸í drop Ä÷³
alter table mail drop id