Class
- Tip&Tech
[¹®¹ý] MySQL¿¡¼ ¿À¶óŬÀÇ rownum ±¸ÇöÇϱâ | |||||
±Û¾´ÀÌ | Ä®¼Ø | ³¯ Â¥ | 07-02-20 12:36 | Á¶ ȸ | 15042 |
---|---|---|---|---|---|
°£ÆíURL |
https://www.phpschool.com/link/tipntech/52106
|
||||
http://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=112831
table¸í : test a_seq b_seq c_seq 1 181 30 2 179 34 3 176 27 4 179 28 5 176 27 6 180 29 7 176 27 ------------------------------------------- select a_seq from test where b_seq='176' and c_seq='27' ¸¦ ÇÏ°Ô µÇ¸é °á°ú a_seq 3 5 ¡ç ¿ä±â!! 7 ÀÌ Ãâ·Â µÇ´Âµ¥... ¿©±â¼ a_seq ÀÇ Æ¯Á¤ °ª, ¿¹¸¦ µé¾î a_seq °¡ 5 ÀÏ °æ¿ì 2¹ø° ¶ó´Â °ÍÀ» ¾î¶»°Ô query ¸¦ ÇØ¾ß µÇ´ÂÁö ¾Ë¼ö ÀÖ³ª¿ä? --------------------------------------------- ÇØ°á¹æ¹ý : °ñ¹ðÀÌ(@) º¯¼ö »ç¿ë --------------------------------------------- set @rownum=0; select (@rownum:=@rownum+1) rownum, a_seq from test where b_seq='176' and c_seq='27'; °á°ú rownum a_seq 1 3 2 5 3 7 |
|||||
|
Àüü´ñ±Û¼ö 20
-
¾ç¾ÆÄ¡È£·©ÀÌ 07-02-20 12:46
¼Ò½ºº¸±â
- ¿À~~ ¾ËÂ¥¹è±â ÆÁÀ̳׿ä... Àß È°¿ëÇÏ°Ú½¿µÂ~ ¤£¤£
-
Ä®¼Ø 07-02-20 12:58
¼Ò½ºº¸±â
-
MySQL ¼³¸í¼¿¡ ³ª¿ÍÀÖ½À´Ï´Ù. ¤Ñ¤Ñ;
http://mysql.byungsoo.net/doc/refman/5.1/en/user-variables.html
-
½Ã¿ìã¿éë 07-02-20 14:08
¼Ò½ºº¸±â
-
ÀÌ°É º¸´Â ¼ø°£ ÇÊÀÌ ÆÅ ²ÈÇû½À´Ï´Ù.
µåµð¾î º¸·ù ÁßÀÌ´ø ±â´ÉÀ» È®ÀåÇÒ ¼ö ÀÖ°Ú±º¿ä ¤Ð_¤Ð -
µþ±âÅ°¿ìÀÚ 07-02-20 15:29
¼Ò½ºº¸±â
-
¾î¶² ±â´É¿¡ »ç¿ëÇϸé ÁÁÀ»±î³¶?
¾Ë°í ½ÍÀº1ìÑ
°í¿îÇÏ·ç º¸³»¼¼¿ä -
µé±¹È 07-03-05 15:04
¼Ò½ºº¸±â
-
À̹ÌÁö °Ô½ÃÆÇÀ̳ª ¹¹ ±×·± ºñ½ÁÇÑ ·ù¿¡¼..
Àüü ±ÛÁÙ ¸î¹ø° ÀÎÁö º¸¿©ÁÖ°í ½ÍÀ»¶§ À¯¿ëÇÕ´Ï´Ù.
Äõ¸®¸¦ µÎ¹ø ³¯¸®Áö ¾Ê°í.. Äõ¸®¹® Çϳª¿¡ ó¸®ÇÒ¼ö ÀÖ´Â ¹æ¹ýµµ ÀÖ½À´Ï´Ù. -
µþ±âÅ°¿ìÀÚ 07-02-20 15:33
¼Ò½ºº¸±â
-
²ÉÈúµí ²ÉÈúµí Á¤È®ÇÏ°Ô ¾È²ÉÈ÷´Â±º¿ä
¼ö·ÃÀÌ ºÎÁ·ÇÑ Å¿Àΰ¡ ¤Ñ¤Ñ?
-
Ä®¼Ø 07-02-21 03:30
¼Ò½ºº¸±â
-
Áú¹®ÇϽźР´«¿¡ Àß ¶ç¶ó°í ÀϺη¯ ±×·¸°Ô ÇѰǵ¥..
¾Æ¹«Æ° µµ¿òµÇ¼Ì´Ù´Ï ´ÙÇàÀÔ´Ï´Ù. ^^
-
ÀÏ»ó´Ù¹Ý»ç 07-02-21 11:35
¼Ò½ºº¸±â
- mysql¿ë º¯¼ö(@ °ñ¹ðÀ̺¯¼ö)¸¦ »ç¿ëÇؼ Áõ°¡°ªÀ» ÀÌ¿ëÇѴٴ°Š°°Àºµ¥¿ä
-
Ä®¼Ø 07-03-05 16:14
¼Ò½ºº¸±â
-
MS-SQL¿¡¼ IDENTITY(1,1) ÀÌ°Å ÇÔ ½áº¸¼¼¿ä.
select IDENTITY(1,1) As rownum, a_seq from test where b_seq='176' and c_seq='27';
1 2 3 4 5 6 7 8 9 10