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

ÓÃÌØÊâµÄMySQLÔËËã·û»ñµÃ¸ü¶àÊý¾Ý±È½Ï¹¦ÄÜ

ÓÃÌØÊâµÄMySQLÔËËã·û»ñµÃ¸ü¶àÊý¾Ý±È½Ï¹¦ÄÜ
Èç¹ûÄãÔÚ×î½ü½øÐйýSELECT»òUPDATE²éѯ£¬ÄÇôÄãºÜ¿ÉÄÜÓõ½¹ýÒ»¸ö»òÕß¶à¸öMySQLµÄ±È½ÏÔËËã·ûÀ´ÏÞÖÆ²éѯµÄÊä³ö½á¹û¡£±È½ÏÊÇ´ó¶àÊýSELECT²éѯ²»¿É·Ö¸îµÄÒ»²¿·Ö£¬¶øMySQLΪÕâÒ»¹¦ÄÜÌṩÁ˺ܶຯÊý£»¸ù¾Ý×î½üÒ»´Îͳ¼Æ£¬ËüÓг¬¹ý20¸öÕâÑùµÄÔËËã·ûºÍº¯Êý£¬´ÓÖøÃûµÄ=ºÍLIKEµ½¸ü¼ÓÄѶ®µÄNOT INºÍSTRCMP()¡£
±¾ÎİÑÖØµã·ÅÔÚһЩ²»Ì«³£¼ûµÄMySQLÊý¾Ý±È½Ïº¯ÊýºÍÔËËã·ûÉÏ£¬ÌÖÂÛËüÃÇ¿ÉÒÔ±»ÈçºÎÔËÓÃÔÚÓ¦ÓóÌÐòÀï±È½Ï±í¸ñ×Ö¶ÎÀïµÄ×Ö·û´®¡¢Êý×ÖºÍÈÕÆÚ£¯Ê±¼ä»òÕßÓû§ÌṩµÄÖµ¡£
 
BETWEEN
BETWEENÔËËã·ûÊDzâÊÔÔÚij¸ö·¶Î§ÄÚÊÇ·ñ´æÔÚÒ»¸öÊýÖµ»òÕßÈÕÆÚÖµµÄÓÐÓ÷½Ê½¡£Õâ¸öÔËËã·û½ÓÊÜÁ½¸ö²ÎÊý——×î´óÖµºÍ×îСֵ£¬²¢²âÊÔËùÌṩµÄÖµÊÇ·ñÔÚÕâÁ½¸öÖµµÄ·¶Î§Ö®ÄÚ¡£Èç¹ûÔÚÕâ¸ö·¶Î§Ö®ÄÚ£¬ÔËËã·û¾Í·µ»ØÒ»¸ö²¼¶ûÖµ——Õæ£»·ñÔò£¬Ëü¾Í·µ»ØÒ»¸öαֵ¡£ÏÂÃæ¾ÍÊÇÒ»¸öÀý×Ó£º
            mysql> SELECT 2350 BETWEEN 100 AND 10000;
            +----------------------------+
            | 2350 BETWEEN 100 AND 10000 |
            +----------------------------+
            |¡¡1 |
            +----------------------------+
            1 row in set (0.18 sec)
ÏÂÃæÁ½¸öÀý×ÓÓõ½ÁËÈÕÆÚÖµ£º
            mysql> SELECT 20060405 BETWEEN 20060101 AND 20070101;
            +----------------------------------------+
            | 20060405 BETWEEN 20060101 AND 20070101 |
            +----------------------------------------+
            |¡¡1 |
 &nb


Ïà¹ØÎĵµ£º

Ô¶³Ì²»ÄÜÁ¬½Ómysql½â¾ö·½·¨

Ô¶³ÌÁ¬½ÓÁíһ̨µçÄÔµÄmysqlµÄÊý¾Ý¿âʱ£¬Èç¹ûÁ¬½Ó²»ÉÏ£¬Õâʱºò¾ÍÒªÔÚ±»Á¬½ÓµÄµçÄÔÉÏÖ´ÐÐÒÔÏÂÃüÁ
Ô­Òò£ºÊÇûÓиøµÇ¼Óû§ÃûÉèÖÃÔ¶³ÌÖ÷»úµÇ¼µÄȨÏÞ
1¡£µÇ¼mysql  £º
Ö´ÐУºmysql -u root -p
2¡£ÐÞ¸Ä MySQL Êý¾Ý¿âÖÐ user ±íÖÐ ¶ÔÓ¦Óû§ÃûµÄ Host ×ֶΣ¬½« localhost ¸ÄΪ %
Ö´ÐУºuse mysql;
ÔÙÖ´ÐУºupd ......

MyEclipse+Tomcat+MySQLµÄ»·¾³´î½¨£¨2010Äê3ÔÂ5ÈÕ)

Ò». ÉèÖò½Ö裺1¡¢ÓÒ¼üµã»÷ÎҵĵçÄÔ£¬Ñ¡ÔñÊôÐÔ£¨¼ûͼ-1£©      
1¡¢µã»÷¸ß¼¶£¬ÔÚ¶Ô»°¿òµÄϲ¿µã»÷»·¾³±äÁ¿
 3¡¢ÔÚϵͳ±äÁ¿¶Ô»°¿òÖУ¬µã»÷н¨½øÐÐÉèÖÃ.
±äÁ¿Ãû£ºJAVA_HOME
±äÁ¿Öµ£ºC:\Program Files\Java\jdk1.6.0_05£¨ÔÚ´ËʹÓõÄÊÇĬÈϰ²×°Â·¾¶£©
ϵͳ±äÁ¿->±à¼­->±ä ......

windowsÏÂPHP5+APACHE+MYSQLÍêÕûÅäÖÃ

Èí¼þ°æ±¾:
php-5.2.13-Win32
apache_2.2.9-win32-x86-no_ssl-r2.msi(×¢Ò⣺APACHE 2.2.X°æ±¾ÒÔÉÏÒªÔö¼Ó²å¼þ²ÅÖ§³ÖPHP 5µÄ)
mysql-5.1.44-win32.msi
ÏÈ×°µÄphp5,Ö±½Ó½âѹÎļþµ½C:\php(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷Éϰ²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó× ......

ÔÚWebLogic 9ÖÐÅäÖÃMySqlµÄÊý¾ÝÔ´

µÚÒ»²½£¬ÏÂÔØMysqlµÄJDBCÇý¶¯³ÌÐò£¬ÃûΪconnectorJ¡£ÏÂÔØÍøÖ·£ºhttp://dev.mysql.com/downloads/connector/j/
½âѹËõzipÎļþºó£¬½«Îļþmysql-connector-java-5.1.12-bin.jarµ½Ä¿Â¼d:\Software\MySQL\MySQL Server 5.1\jdbcdriver\ÖÐ
µÚ¶þ²½£¬ÐÞ¸ÄÎļþd:\Software\bea\WebLogic 9.23\user_projects\domains\MyDomain\bin\s ......

PHPºÍMYSQLµÄ±àÂëÎÊÌâ

1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
  MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
  Collations·­³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCol ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ