1302 ¹ø ±ÛÀÇ ´äÀå±Û: Re: Re: Re: ½© ÇÁ·Î±×·¥? |
±Û¾´ÀÌ: »êÀÌ
[ȨÆäÀÌÁö]
|
±Û¾´³¯: 2003³â 01¿ù 24ÀÏ 23:26:49 ±Ý(Àú³á) |
Á¶È¸: 643 |
[°¿µº¸]´ÔÀÌ ³²±â½Å ±Û:
>´äº¯ °¨»çÇÕ´Ï´Ù.
>
>mysql ¿¬°áÇÏ´Â ºÎºÐÀÌ ÀÌÇØ°¡ ¾È°¡°Åµç¿© Áö±Ý »êÀÌ´ÔÀÌ ÇϽŰŴÂ
>
>½©¿¡¼ ¿¬°áÇÏ´Â ¹æ½ÄÀÌÁ®?
>
>result=`$mysql $mysql_connect $mysql_db -e "$sql" 2>/dev/null`
>
ÀÌ°ÍÀº ¿¹¸¦µé¾î
/usr/local/mysql/bin/mysql -h localhost -u user --password=xxx \
hosting -e "SELECT uid FROM member WHERE type = 'free'"
ÀÇ ½ÇÇà °á°ú¸¦ result¿¡ ³Ö¾î¶ó´Â ÀǹÌÀÔ´Ï´Ù.
½©¿¡¼ Á÷Á¢ À§ÀÇ ¸í·É¾î¸¦ ÀÔ·ÂÇØ º¸¼¼¿ä.
>IFS='
>
IFS='
'
ÀÔ´Ï´Ù. ³ªÁß¿¡ for ¹®À» ½ÇÇàÇÒ¶§ ±¸ºÐÀÚ¸¦ newlineÀ¸·Î
Àç¼³Á¤ÇÏ´Â ÀǹÌÀÔ´Ï´Ù. (±âº»°ªÀº °ø¹éÀÓ)
>¿©±â¼¿© ÀÌ°Ô ¾î¶»°Ô µÇ´Â°Å¿¡¿©? bash °í±Þ½ºÅ©¸³Æ®¿¡¼ ã¾Æº¸´Ï±î..
>mysql °ü·ÃµÈ°ÍÀÌ ¾ø¾î¼¿© ..
>
>i=0
>for mallid in $result ; do
> if [ "$i" -gt 0 ] ; then ## ù¹ø°´Â Ä÷³ À̸§À̹ǷΠ°Ç³Ê¶ê
> echo "$i start of $mallid install"
> each_install "$mallid"
> echo "$i end of $mallid install"
> fi
> i=$(($i+1))
>done
>
>
>¿©±â¼´Â $result ¸¸Å µ¹¸®¶ó´Â°Í °°Àºµ¥ $mallid ¸¸ Àû¾îÁÖ¸é µÇ³ª¿©?
>¹¹ mysql_result($result,0,0) ÀÌ·±½ÄÀ¸·Î ÇؾßÇҰ͸¸ °°Àºµ¥..
>
BASH¿¡¼´Â mysql_result() ÀÌ·± ÇÔ¼ö³ª ¸í·É¾î´Â ¾ø½À´Ï´Ù.
$result¿¡ ÀÖ´Â Á¤º¸¸¦ newline À¸·Î ±¸ºÐÇؼ ±× ÇϳªÀÇ °ªÀ»
mailid¿¡ ÀúÀåÇÏ´Â for ¹®ÀÔ´Ï´Ù.
>¿©±â¼ ¿¡·¯°¡ ³ª¼ mallid ¸¦ ÂïÁö ¸øÇÕ´Ï´Ù.
>
>
>¾Æ .. ±×·¯´Ï±î.. mysql ¿¬°áÀ» Á» ¼³¸íÁ» ÇØÁÖ¼¼¿ä ¾Æ´Ï¸é ¸Þ´º¾óÀ̳ª
>
>´äº¯ ¶Ç ÁÖ¼¼¿©>>>
>
>
>
Ä¿¸Çµå ¶óÀο¡¼
# /usr/local/mysql/bin/mysql -h localhost -u root --password=xxx
hosting -e "SELECT uid FROM member WHERE type = 'free'"
À» ½ÇÇàÇØ º¸¼¼¿ä. ÇÑÁÙ¿¡ ¿¬¼ÓÇؼ ÀÔ·Â,
¹°·Ð xxx ºÎºÐÀº ÇØ´ç ¾ÏÈ£·Î ¹Ù²Ù¾î¾ß ÇÕ´Ï´Ù.
========================================
|
ÀÌÀü±Û : Re: Re: ½© ÇÁ·Î±×·¥?
´ÙÀ½±Û : ´äº¯ °¨»çÇÕ´Ï´Ù. ³Ê¹« Ä£ÀýÇϼſ©..
|
from 61.254.75.40
JS(Redhands)Board 0.4 +@
|