Mysql my.ini ÅäÖÃÎļþÏê½â
±¾ÎÄ×ªÔØ×Ô£ºhttp://www.54xue.com/?action-viewnews-itemid-7498
#BEGIN CONFIG INFO
#DESCR: 4GB RAM, ֻʹÓÃInnoDB, ACID, ÉÙÁ¿µÄÁ¬½Ó, ¶ÓÁиºÔØ´ó
#TYPE: SYSTEM
#END CONFIG INFO
#
# ´ËmysqlÅäÖÃÎļþÀý×ÓÕë¶Ô4GÄÚ´æ
# Ö÷ҪʹÓÃINNODB
#´¦Àí¸´ÔÓ¶ÓÁв¢ÇÒÁ¬½ÓÊýÁ¿½ÏÉÙµÄmysql·þÎñÆ÷
#
# ½«´ËÎļþ¸´ÖƵ½/etc/my.cnf ×÷Ϊȫ¾ÖÉèÖÃ,
# mysql-data-dir/my.cnf ×÷Ϊ·þÎñÆ÷Ö¸¶¨ÉèÖÃ
# (@localstatedir@ for this installation) »òÕß·ÅÈë
# ~/.my.cnf ×÷ΪÓû§ÉèÖÃ.
#
# ÔÚ´ËÅäÖÃÎļþÖÐ, Äã¿ÉÒÔʹÓÃËùÓгÌÐòÖ§³ÖµÄ³¤Ñ¡Ïî.
# Èç¹ûÏë»ñϤ³ÌÐòÖ§³ÖµÄËùÓÐÑ¡Ïî
# ÇëÔÚ³ÌÐòºó¼ÓÉÏ"--help"²ÎÊýÔËÐгÌÐò.
#
# ¹ØÓÚ¶ÀÁ¢Ñ¡Ïî¸ü¶àµÄϸ½ÚÐÅÏ¢¿ÉÒÔÔÚÊÖ²áÄÚÕÒµ½
#
#
# ÒÔÏÂÑ¡Ïî»á±»MySQL¿Í»§¶ËÓ¦ÓöÁÈ¡.
# ×¢ÒâÖ»ÓÐMySQL¸½´øµÄ¿Í»§¶ËÓ¦ÓóÌÐò±£Ö¤¿ÉÒÔ¶ÁÈ¡Õâ¶ÎÄÚÈÝ.
# Èç¹ûÄãÏëÄã×Ô¼ºµÄMySQLÓ¦ÓóÌÐò»ñÈ¡ÕâЩֵ
# ÐèÒªÔÚMySQL¿Í»§¶Ë¿â³õʼ»¯µÄʱºòÖ¸¶¨ÕâЩѡÏî
#
[client]
#password = [your_password]
port = @MYSQL_TCP_PORT@
socket = @MYSQL_UNIX_ADDR@
# *** Ó¦Óö¨ÖÆÑ¡Ïî ***
#
# MySQL ·þÎñ¶Ë
#
[mysqld]
# Ò»°ãÅäÖÃÑ¡Ïî
port = @MYSQL_TCP_PORT@
socket = @MYSQL_UNIX_ADDR@
# back_log ÊDzÙ×÷ϵͳÔÚ¼àÌý¶ÓÁÐÖÐËùÄܱ£³ÖµÄÁ¬½ÓÊý,
# ¶ÓÁб£´æÁËÔÚMySQLÁ¬½Ó¹ÜÀíÆ÷Ï̴߳¦Àí֮ǰµÄÁ¬½Ó.
# Èç¹ûÄãÓзdz£¸ßµÄÁ¬½ÓÂʲ¢ÇÒ³öÏÖ"connection refused" ±¨´í,
# Äã¾ÍÓ¦¸ÃÔö¼Ó´Ë´¦µÄÖµ.
# ¼ì²éÄãµÄ²Ù×÷ϵͳÎĵµÀ´»ñÈ¡Õâ¸ö±äÁ¿µÄ×î´óÖµ.
# Èç¹û½«back_logÉ趨µ½±ÈÄã²Ù×÷ϵͳÏÞÖÆ¸ü¸ßµÄÖµ,½«»áûÓÐЧ¹û
back_log = 50
# ²»ÔÚTCP/IP¶Ë¿ÚÉϽøÐмàÌý.
# Èç¹ûËùÓеĽø³Ì¶¼ÊÇÔÚͬһ̨·þÎñÆ÷Á¬½Óµ½±¾µØµÄmysqld,
# ÕâÑùÉèÖý«ÊÇÔöÇ¿°²È«µÄ·½·¨
# ËùÓÐmysqldµÄÁ¬½Ó¶¼ÊÇͨ¹ýUnix sockets »òÕßÃüÃû¹ÜµÀ½øÐеÄ.
# ×¢ÒâÔÚwindowsÏÂÈç¹ûûÓдò¿ªÃüÃû¹ÜµÀÑ¡Ïî¶øÖ»ÊÇÓôËÏî
# (ͨ¹ý "enable-named-pipe" Ñ¡Ïî) ½«»áµ¼ÖÂmysql·þÎñûÓÐÈκÎ×÷ÓÃ!
#skip-networking
# MySQL ·þÎñËùÔÊÐíµÄͬʱ»á»°ÊýµÄÉÏÏÞ
# ÆäÖÐÒ»¸öÁ¬½Ó½«±»SUPERȨÏÞ±£Áô×÷Ϊ¹ÜÀíÔ±µÇ¼.
# ¼´±ãÒѾ´ïµ½ÁËÁ¬½ÓÊýµÄÉÏÏÞ.
max_connections = 100
# ÿ¸ö¿Í»§¶ËÁ¬½Ó×î´óµÄ´íÎóÔÊÐíÊýÁ¿,Èç¹û´ïµ½ÁË´ËÏÞÖÆ.
# Õâ¸ö¿Í»§¶Ë½«»á±»MySQL·þÎñ×èÖ¹Ö±µ½Ö´ÐÐÁË"FLUSH HOSTS" »òÕß·þÎñÖØÆô
# ·Ç·¨µÄÃÜÂëÒÔ¼°ÆäËûÔÚÁ´½ÓʱµÄ´íÎó»áÔö¼Ó´ËÖµ.
# ²é¿´ "Aborted_connects" ״̬À´»
Ïà¹ØÎĵµ£º
MySQLÖеÄÊý¾ÝÓø÷ÖÖ²»Í¬µÄ¼¼Êõ´æ´¢ÔÚÎļþ(»òÕßÄÚ´æ)ÖС£ÕâЩ¼¼ÊõÖеÄÿһÖÖ¼¼Êõ¶¼Ê¹Óò»Í¬µÄ´æ´¢»úÖÆ¡¢Ë÷Òý¼¼ÇÉ¡¢Ëø¶¨Ë®Æ½²¢ÇÒ×îÖÕÌṩ¹ã·ºµÄ²»Í¬µÄ¹¦ÄܺÍÄÜÁ¦¡£Í¨¹ýÑ¡Ôñ²»Í¬µÄ¼¼Êõ£¬ÄãÄܹ»»ñµÃ¶îÍâµÄËÙ¶È»òÕß¹¦ÄÜ£¬´Ó¶ø¸ÄÉÆÄãµÄÓ¦ÓõÄÕûÌ幦ÄÜ¡£
ÀýÈ磬Èç¹ûÄãÔÚÑо¿´óÁ¿µÄÁÙʱÊý¾Ý£¬ÄãÒ²ÐíÐèҪʹÓÃÄÚ´æ´æ´¢ÒýÇæ¡£ÄÚ´æ´æ´ ......
²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄ·½·¨
(Ò»)
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´Åжϣ¬Ö»Á ......
ÔÚVC6ÖÐʹÓÃc API·½Ê½Á¬½ÓMySQLÊý¾Ý¿â
Ò»¡¢»·¾³ÅäÖÃ
1¡¢ÔÚMySqlµÄ¹Ù·½ÍøÕ¾ÏÂÔØmysql-connector-c-noinstall£¬²¢½«½âѹºóµÄbinºÍincludeÎļþ¼Ð¿½±´µ½MysqlµÄ°²×°Ä¿Â¼
2¡¢ÉèÖÃVC6»·¾³£¬ÔÚvc¹¤¾ß-Ñ¡Ïî-Ŀ¼£¬¼ÓÈë¸Õ²ÅµÄIncludeÎļþ¼ÐµÄ·¾¶£¬ÀýÈ磺C:\Program Files\MySQL\MySQL Server 5.1\include
¶þ¡¢¹¤³ÌÉèÖÃ
3¡¢½«li ......
ʹÓÃÄÚ²¿º¯Êýinstr£¬¿É´úÌæ´«Í³µÄlike·½Ê½²éѯ£¬²¢ÇÒËٶȸü¿ì¡£
instrº¯Êý£¬µÚÒ»¸ö²ÎÊýÊÇ×ֶΣ¬µÚ¶þ¸ö²ÎÊýÊÇÒª²éѯµÄ´®£¬·µ»Ø´®µÄλÖ㬵ÚÒ»¸öÊÇ1£¬Èç¹ûûÕÒµ½¾ÍÊÇ0.
ÀýÈ磬
select name from tpl_user where 1 and instr(`name`,’jack’);
¿É²éѯÃû×ÖÖдøjackµÄÃû×Ö¡£ ......
Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü
2009-12-15 16:47
Jsp »·¾³Ä¿Ç°×îÁ÷ÐеÄÊÇ Tomcat5.0¡£Tomcat5.0 ×Ô¼º°üº¬Ò»¸ö Web ·þÎñÆ÷£¬Èç¹ûÊDzâÊÔ£¬¾Íû±ØÒª°Ñ Tomcat Óë IIS »ò Apache ¼¯³ÉÆðÀ´¡£ÔÚ Tomcat ×Ô´øµÄ Web ·þÎñÆ÷Ï¿ÉÒÔ½øÐÐ Jsp ²âÊÔ¡£
°²×° Tomcat5.0 ǰÐèÒª°²×° JDK(Èç¹ûÊÇ Windows server ......