Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

shell Öе÷Óà mysql ²Ù×÷

#!/bin/bash
#ɾ³ý100¸öÊý¾Ý¿âÖеÄ1000¸ö±íµÄ¹ýÆÚÊý¾Ý
DBHOST="127.0.0.1"
DBPWD="pwd"
DBUSER="root"
MYSQLBIN="/usr/local/mysql/bin/mysql"
for((dbindex = 0;dbindex < 100;dbindex++))
do
   for((tabindex = 0;tabindex < 10;tabindex++))
   do
    if [ $dbindex -lt 10 ]; then
  del="delete from gs_map_0${dbindex}.t_${tabindex}";
    else
  del="delete from gs_map_${dbindex}.t_${tabindex}";
    fi
    del=${del}" where Fcreate_time < UNIX_TIMESTAMP() - 86400"
    bin=`${MYSQLBIN} -u${DBUSER} -p${DBPWD} -h${DBHOST} -e"${del}"`
    $bin
    #echo ${bin} 
    #echo $del >>/tmp/aaa.txt
    sleep 5
   done
done
#crontab configure
# 0 3 * * * clear.sh > /dev/null 2>&1


Ïà¹ØÎĵµ£º

Joomla! ½¨Õ¾³ÌÐòµÄ°²×°(xampp¡¢apacheºÍMysqlÉèÖÃ)

´Ë´¦ÔËÓÃÁËÒ»¸ö¼¯³ÉµÄxampp¼Ü¹¹¡£²»Óõ¥¶ÀÈ¥°²×°apache·þÎñÆ÷£¬mysqlÊý¾Ý¿â£¬µÈµÈ¡£
£¨Ò»£©XamppµÄ°²×°
   ÏÂÔØxampp
1.       Ë«»÷xampp£¬µã»÷ÏÂÒ»²½£¬ÏÂÒ»²½£¬ÈçÊÇ£¬¾Í°²×°ÁËxampp¡££¨´Ë´¦°²×°ÔÚÁËc£º\sandboxÏÂÃæÁË£©
 
2. ½øÐÐxampp°²×°ÊÇ·ñ³É¹¦µÄ²âÊÔ£º
´ò¿ª£ºc:\ ......

MySQL½Ì³Ì£ºOrder ByÓ÷¨


ÏȰ´ÕÕÏÂÃæµÄ±í½á¹¹´´½¨mysql_order_by_testÊý¾Ý±í£¬ÎÒÃÇÓÃʵÀýÒ»µãÒ»µã¸æËßÄ㣬MySQL order byµÄÓ÷¨¡£
¡¡¡¡ORDER BY uid ASC
¡¡¡¡°´ÕÕuidÕýÐò²éѯÊý¾Ý£¬Ò²¾ÍÊǰ´ÕÕuid´ÓСµ½´óÅÅÁÐ
¡¡¡¡ORDER BY uid DESC
¡¡¡¡°´ÕÕuidÄæÐò²éѯÊý¾Ý£¬Ò²¾ÍÊǰ´ÕÕuid´Ó´óµ½Ð¡ÅÅÁÐ
¡¡¡¡ÎÒÃÇÀ´¿´
SELECT * from mysql_order_by_test OR ......

С̸MySQL×Ö·û¼¯


×÷/ÒëÕߣºÒ¶½ðÈÙ£¨Email: £©£¬À´Ô´£ºhttp://imysql.cn£¬×ªÔØÇë×¢Ã÷×÷/ÒëÕߺͳö´¦£¬²¢ÇÒ²»ÄÜÓÃÓÚÉÌÒµÓÃ;£¬Î¥Õ߱ؾ¿¡£
Ê×ÏÈ,ÕâÆ¬ÎÄÕ´¿´âÊÇÎҵĸöÈ˾­Ñé̸֮,ÊÊÓÃÓÚÎÒ³£¼ûµÄ»·¾³¼°ÏîÄ¿ÖÐ.
¸öÈ˽¨Òé,Êý¾Ý¿â×Ö·û¼¯¾¡Á¿Ê¹ÓÃutf8(HTMLÒ³Ãæ¶ÔÓ¦µÄÊÇutf-8),ÒÔʹÄãµÄÊý¾ÝÄܺÜ˳ÀûµÄʵÏÖÇ¨ÒÆ,ÒòΪutf8×Ö·û¼¯ÊÇĿǰ×îÊʺÏÓÚÊ ......

mysqlÃüÁîÐв»Ö´ÐкÍÃüÁîÐÐÖÐÎÄÂÒÂëµÄ½â¾ö


1£ºMysql ÃüÁî²»¿ÉÒÔÖ´ÐÐ
Ô­Òò £ººÇºÇ ±ÈÈç show databases µÄÃüÁî £¬Ö´ÐÐÍêÖ®ºó ɶҲûÓÐ £¬×Ðϸ ÕÒÁËÔ­Òò £¬Oh my god  ÉÙÁË ·ÖºÅ¡£
Ӧд³É£ºshow databases;
2£ºÃüÁîÐÐÖÐÎÄÂÒÂëÎÊÌâ
ÏÖÏó£ºmysqlµÄĬÈϱàÂëÉèÖÃΪutf-8£¬Ò³ÃæÒÔutf-8µÄ±àÂ뷽ʽдÈëµ½Êý¾Ý¿â¡£Óù¤¾ß²é¿´Ò»ÇÐÕý³££¬µ«´ÓmysqlµÄÃüÁîÐжÁÊý¾Ý³öÀ´× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ