mysql ÏúÊÛÊý¾Ý°´ÈÕÆÚÐÐת»»ÎªÁÐ Óï¾ä: CREATE PROCEDURE `PROC_GET_SUM_Report`( tag char(1), btime varchar(10), etime varchar(10)) BEGIN declare $stm varchar(8000); declare $rowcnt int; declare $mycnt int; declare $i int; set $mycnt = 0; set $i = 1; set $stm='select storeno as ±àºÅ,storename as µêÃû,estorename as µêÓ¢ÎÄÃû'; if tag='0' then select count(dis...
by scosure - MySQLÎĵµÖÐÐÄ - 2009-11-10 11:56:28 ÔĶÁ£¨2399£© »Ø¸´£¨0£©
±¾Ìû×îºóÓÉ cenalulu ÓÚ 2012-07-31 10:23 ±à¼ ±í mysql> select * from favorite_food; +-----------+--------+ | person_id | food | +-----------+--------+ | 1 | cookie | | 1 | nachos | | 1 | pizza | | 2 | kk | +-----------+--------+ ¼ÙÉ裺 ͬһ¸öperson_id×î¶àÔÊÐí´øÈý¸öfoodÖµ¡£¼´Í¬Ò»¸öperson_idÔڸñíÖÐÖÁ¶à³öÏÖ3´Î¡£ ÎÒÏëÒªµÄ½á¹ûÊÇ£º +-----------+--------+-----...
´ÓÊý¾Ý¿âÖжÁ³ö¶àÐÐÊý¾Ý£¬ÓÃshellÑ»·¶Á³öÿһÐУ¬²åÈëµ½Êý¾Ý¿âÖС£²å³ÉÒ»Ìõ¼Ç¼¡£ #!/bin/sh TxIp=192.168.0.103 bindir=/usr/local/mysql/bin/mysql datadir=/data/txdata/test yestoday=`date -I --date='-1 days'` #echo $Date >> load.txt #[ -f load.txt ] && rm -f load.txt for n in $(seq 10 132) do IP=192.168.0.$n $bindir -uwaptx -p"(YDtx405)" -h $TxIp -P12341 --default_character_set=GBK txbackend -e "sele...
grant select,insert on test.abc to 'test'@'%' identified by '111'; ÒÔÉÏ¿ÉÒÔÉ趨±íȨÏÞ£¬ÇëÎÊÈçºÎÉ趨ÁÐȨÏÞ£¿
µÚ11Õ£ºÁÐÀàÐÍ Ä¿Â¼ 11.1. ÁÐÀàÐ͸ÅÊö 11.1.1. ÊýÖµÀàÐ͸ÅÊö 11.1.2. ÈÕÆÚºÍʱ¼äÀàÐ͸ÅÊö 11.1.3. ×Ö·û´®ÀàÐ͸ÅÊö 11.2. ÊýÖµÀàÐÍ 11.3. ÈÕÆÚºÍʱ¼äÀàÐÍ 11.3.1. DATETIME¡¢DATEºÍTIMESTAMPÀàÐÍ 11.3.2. TIMEÀàÐÍ 11.3.3. YEARÀàÐÍ 11.3.4. Y2KÊÂÒ˺ÍÈÕÆÚÀàÐÍ 11.4. StringÀàÐÍ 11.4.1. CHARºÍVARCHARÀàÐÍ 11.4.2. BINARYºÍVARBINARYÀàÐÍ 11.4.3. BLOBºÍTEXTÀàÐÍ 11.4.4. ENUMÀàÐÍ 11.4.5. SE...
´ó¼ÒºÃ£¬ÎÒÓÐÁ½¸öʱ¼ä´Á1355543041 ¡¢1354845629 ÎÒÏë°ÑËûÃǵIJîֵת»¯³ÉСʱ¡¢·ÖÖÓ¡¢ÃëµÄ¸ñʽ¡£²»È磺3Сʱ10·ÖÖÓ2Ãë¡£Çë¸÷λ´óÏÀ´Í½Ì
±¾Ìû×îºóÓÉ liyihongcug ÓÚ 2011-07-28 16:31 ±à¼ ¾ªÌ¾Õâ¸ö¹¦ÄÜ SELECT * FROM iptocountry where inet_aton('10.0.3.1') between startip AND endip;f À´×Ô http://ip-to-country.webhosting.info/node/view/6 Èç¹ûÄÜÅäºÏ½Å±¾×÷ÕýÔò±íʾʽ¹ýÂËÄÇЩȱÉÙ. »òÕß²»ÍêÕûµÄip¾ÍÌ«ºÃÁË Êµ¼ÊÉÏ͵ÀÁ Ö±½ÓÖ´ÐÐÅÐ¶Ï select inet_aton('10.0.') ·µ»Ø¿Õ±íʾ·Ç·¨ ·ñÔò¿ÉÒԵõ½´Óip È¥¹ú¼ÒÃû * INET_ATON(expr) ¸ø³öÒ»¸ö×÷Ϊ×Ö...
mysqlÖ§³Ö¶àÖÖÁÐÀàÐÍ£ºÊýÖµÀàÐÍ¡¢ÈÕÆÚ/ʱ¼äÀàÐͺÍ×Ö·û´®(×Ö·û)ÀàÐÍ¡£±¾ÕÂÊ×ÏȶÔÕâЩÁÐÀàÐͽøÐÐÁ˸ÅÊö£¬È»ºó¸ü¼ÓÏêϸµØÃèÊöÁ˸÷ÖÖÁеÄÀàÐÍ£¬ÒÔ¼°ÁÐÀàÐÍ´æ´¢ÐèÇóµÄ×ܽᡣ¸ÅÊöºÜ¼òµ¥¡£¹ØÓÚ¾ßÌåÁÐÀàÐ͵ÄÏêϸÐÅÏ¢Ó¦²éÔÄÏêϸµÄÃèÊö£¬ÀýÈçÖ¸¶¨ÖµÊ±ÔÊÐíʹÓõĸñʽ¡£ mysqlÖ§³Ö´¦Àí¿Õ¼äÊý¾ÝµÄÀ©Õ¹Ãû¡£¹ØÓÚ¿Õ¼äÀàÐ͵ÄÐÅÏ¢²Î¼û µÚ19Õ£º mysqlÖеĿռäÀ©Õ¹ ¡£ ¼¸ÖÖÁÐÀàÐÍÃèÊöʹÓÃÁËÏÂÊö¹ßÀý£º ¡¤ M ±íʾ×î´óÏÔʾ¿í¶È¡£×î´óÓÐЧÏÔʾ¿í...
mysql5.2 for win .net connect ÔÚvb2005ÖÐÓÃdatagridviewÏÔʾ»ñÈ¡µÄÊý¾Ý, ÄÚÈÝΪÖÐÎÄ,ÏÔʾÕý³£,¿ÉÊÇÁбêÌâÊÇÂÒÂë. ÈçºÎ½â¾ö?
ijһÁеÄÀàÐÍΪint¡«¡« ÎÒÈç¹û²ÅÄÜÇóÕâÒ»ÁеÄ×ܺͣ¿ ²»»áÒ»ÌõÒ»ÌõÈ¡³öÀ´È»ºóÏà¼Ó°É£¿ mysqlÓÐÄÚÖú¯ÊýÂ𣿠ÎÒ·ÁËÒ»ÏÂÊֲᣬºÃÏñûÓÐÌáµ½¡«