1302 ¹ø ±ÛÀÇ ´äÀå±Û: ´äº¯ °¨»çÇÕ´Ï´Ù. ³Ê¹« Ä£ÀýÇϼſ©.. |
±Û¾´ÀÌ: °¿µº¸
|
±Û¾´³¯: 2003³â 01¿ù 25ÀÏ 15:06:46 Åä(¿ÀÈÄ) |
Á¶È¸: 542 |
[»êÀÌ]´ÔÀÌ ³²±â½Å ±Û:
>[°¿µº¸]´ÔÀÌ ³²±â½Å ±Û:
>
>>´äº¯ °¨»çÇÕ´Ï´Ù.
>>
>>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: Re: ½© ÇÁ·Î±×·¥?
´ÙÀ½±Û : ÀÌ·±ÀÌ·± ¾î¼ÁÒ??
|
from 211.186.36.143
JS(Redhands)Board 0.4 +@
|