ChinaUnix.net
Ïà¹ØÎÄÕÂÍÆ¼ö:

mysql ÐÐת»»ÁÐ

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´Î¡£ ÎÒÏëÒªµÄ½á¹ûÊÇ£º +-----------+--------+-----...

by ciedecem - MySQL - 2012-07-31 10:39:23 ÔĶÁ£¨1762£© »Ø¸´£¨8£©

´ÓÊý¾Ý¿âÖжÁ³ö¶àÐÐÊý¾Ý£¬ÓÃ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...

by nychenlei - LinuxÎĵµ×¨Çø - 2009-08-10 15:50:07 ÔĶÁ£¨1855£© »Ø¸´£¨0£©

ÈçºÎ½«mysql 3.23 µÄÊý¾Ý¿â£¬Éý¼¶Îªmysql 4.1µÄÊý¾Ý¿â¡£ ³ÌÐòÒª±äÂ𣿣¿

by epai - MySQL - 2006-08-05 16:48:22 ÔĶÁ£¨953£© »Ø¸´£¨1£©

grant select,insert on test.abc to 'test'@'%' identified by '111'; ÒÔÉÏ¿ÉÒÔÉ趨±íȨÏÞ£¬ÇëÎÊÈçºÎÉ趨ÁÐȨÏÞ£¿

by xiner10 - MySQL - 2009-04-07 15:59:54 ÔĶÁ£¨2935£© »Ø¸´£¨2£©

µÚ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...

by biaoflying - MySQLÎĵµÖÐÐÄ - 2008-03-30 18:11:30 ÔĶÁ£¨1356£© »Ø¸´£¨0£©

´ó¼ÒºÃ£¬ÎÒÓÐÁ½¸öʱ¼ä´Á1355543041 ¡¢1354845629 ÎÒÏë°ÑËûÃǵIJîֵת»¯³ÉСʱ¡¢·ÖÖÓ¡¢ÃëµÄ¸ñʽ¡£²»È磺3Сʱ10·ÖÖÓ2Ãë¡£Çë¸÷λ´óÏÀ´Í½Ì

by mlxahcf - MySQL - 2013-04-24 17:33:11 ÔĶÁ£¨1104£© »Ø¸´£¨3£©

±¾Ìû×îºóÓÉ 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) ¸ø³öÒ»¸ö×÷Ϊ×Ö...

by liyihongcug - MySQL - 2011-07-29 17:15:50 ÔĶÁ£¨2177£© »Ø¸´£¨1£©

mysqlÖ§³Ö¶àÖÖÁÐÀàÐÍ£ºÊýÖµÀàÐÍ¡¢ÈÕÆÚ/ʱ¼äÀàÐͺÍ×Ö·û´®(×Ö·û)ÀàÐÍ¡£±¾ÕÂÊ×ÏȶÔÕâЩÁÐÀàÐͽøÐÐÁ˸ÅÊö£¬È»ºó¸ü¼ÓÏêϸµØÃèÊöÁ˸÷ÖÖÁеÄÀàÐÍ£¬ÒÔ¼°ÁÐÀàÐÍ´æ´¢ÐèÇóµÄ×ܽᡣ¸ÅÊöºÜ¼òµ¥¡£¹ØÓÚ¾ßÌåÁÐÀàÐ͵ÄÏêϸÐÅÏ¢Ó¦²éÔÄÏêϸµÄÃèÊö£¬ÀýÈçÖ¸¶¨ÖµÊ±ÔÊÐíʹÓõĸñʽ¡£ mysqlÖ§³Ö´¦Àí¿Õ¼äÊý¾ÝµÄÀ©Õ¹Ãû¡£¹ØÓÚ¿Õ¼äÀàÐ͵ÄÐÅÏ¢²Î¼û µÚ19Õ£º mysqlÖеĿռäÀ©Õ¹ ¡£ ¼¸ÖÖÁÐÀàÐÍÃèÊöʹÓÃÁËÏÂÊö¹ßÀý£º ¡¤ M ±íʾ×î´óÏÔʾ¿í¶È¡£×î´óÓÐЧÏÔʾ¿í...

by heamon - MySQLÎĵµÖÐÐÄ - 2007-11-21 23:14:55 ÔĶÁ£¨1538£© »Ø¸´£¨0£©

mysql5.2 for win .net connect ÔÚvb2005ÖÐÓÃdatagridviewÏÔʾ»ñÈ¡µÄÊý¾Ý, ÄÚÈÝΪÖÐÎÄ,ÏÔʾÕý³£,¿ÉÊÇÁбêÌâÊÇÂÒÂë. ÈçºÎ½â¾ö?

by shada - MySQL - 2007-04-14 11:24:03 ÔĶÁ£¨2247£© »Ø¸´£¨2£©

ijһÁеÄÀàÐÍΪint¡«¡« ÎÒÈç¹û²ÅÄÜÇóÕâÒ»ÁеÄ×ܺͣ¿ ²»»áÒ»ÌõÒ»ÌõÈ¡³öÀ´È»ºóÏà¼Ó°É£¿ mysqlÓÐÄÚÖú¯ÊýÂ𣿠ÎÒ·­ÁËÒ»ÏÂÊֲᣬºÃÏñûÓÐÌáµ½¡«

by lemony - MySQL - 2006-01-21 22:10:58 ÔĶÁ£¨6875£© »Ø¸´£¨3£©