ÔõÑùѧMYSQL - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ËÓÐMYSQLÊÓÆµ¼°×ÊÁÏ£¬Çë·¢ËÍÖÁtanhualin1985@163.com£¬±¾È˷dz£¸Ðл
ÏȶÁN±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ£¨µÚËİ棩¡· Íõɺ ÈøÊ¦ìÓ ¸ßµÈ½ÌÓý³ö°æÉç (ÕÆÎÕ»ù´¡ÖªÊ¶ºÍ¸ÅÄî) È»ºóÔÙ´ÖÂÔä¯ÀÀÒ»±éMYSQLµÄ¹Ù·½Êֲᡣ£¨·½±ãÒÔºó²éÕÒ£¬±ÜÃâÀàËÆÓÚ¿¼ÊÔµÄʱºò£¬¸øÄã±¾ÕþÖÎÊéÒ²²»ÖªµÀ´ð°¸ÔÚµÚ¼¸Õ£¬µÚ¼¸Ò³£©MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.htmlÒýÓà ËÓÐMYSQLÊÓÆµ¼°×ÊÁÏ£¬Çë·¢ËÍÖÁtanhualin1985@163.com£¬±¾È˷dz£¸Ðл ÏÂÒ»±¾<<MySQLȨÍþÖ¼ÄÏ>>£¬ÕÕ×ÅÉϱßʵ×÷£¬È»ºó£¬Online Help¾³£´ò¿ª··¡£²»ÐèҪʲôÊÓÆµµÄ¡£ ÏÈ¿´¿´ÓйØÊý¾Ý¿âµÄ»ù±¾ÖªÊ¶£¬ÔÙ¿´MYSQLµÄHELP£¬¶à¶¯ÊÖÁ·Ï° ¿´¹Ù·½ÊÖ²á°É¡£ ¶¯ÊÖ+¿´Ê飡
Ïà¹ØÎÊ´ð£º
¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬ Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ a ......
MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖà ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123*** £¿ ¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿ 2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
ÎÒÐèҪʹÓÃnhibernateµ÷ÓÃmysqlº¯Êý£¬ÀàËÆµÄsqlÓï¾ä£º select * from concat(',', ServiceCodes, ',') like '%,33,%'; »òselect * from (','||ServiceCodes||',') like '%,33,%'; ËùÒÔÎÒ¾ÍÕâÑùµ÷Ó㺠//..... ......
¸ãÁËÒ»¸öÏÂÎçÁË£¬ËÑË÷ÁËÍøÂ绹Êǽâ¾ö²»ÁË...Ï£Íû¸ßÊÖ°ïæ½â¾öÏ Դ´úÂ룺 private void SendPhoto(HttpServletRequest request, HttpServletResponse response) { String name=request.getParamet ......