Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : mysql

mysql like µÄÓ÷¨

select * from table where name like "%123%";
ÕâÑùÊDzéѯ³ö Ãû×ÖÖаüº¬123 µÄÊý¾Ý£¬ÎÒÈç¹ûÒª²éѯÃû×ÖÖв»°üº¬123µÄÊý¾Ý Ôõô²éÄØ£¿
select * from table where name no like "%123%"; ºÃÏñ²»ÐС£
select * from table where name not like "%123%"; ºÃÏñ²»ÐÐ
{{ ......

¹òÇ󣡣¡£¡ ¹ØÓÚJAVAÓëmySqlµÄÎÊÌâ¡£¡£¡£

Èý¸öÎÊÌ⣺

£¨1£©ÊµÏÖ JAVA·ÃÎÊmySqlÊý¾Ý¿â¡£¡£

¿ÉÒÔ¸ø³öʵÀý´úÂëÂð£¿

°³Ö»»á.NET,

ÒªÇóÔÚJ2EE»·¾³ÏÂÔõôʵÏÖ£¿

£¨2£©JAVA·ÃÎÊmySqlÊý¾Ý¿âÒª²»ÒªÇý¶¯£¿

£¨3£©EclipseÓÐwebserviceÂð£¿


¿ÏÇó¸÷λÐֵܽãÃ㬸ø³öʵÀý´úÂ룡¸Ð¼¤²»¾¡¡£¡£



ÎÊÌâ1:ÓÃJDBC·ÃÎÊ ......

WIN7 X64ϵÄApache+Mysql+PhpÅäÖÃ

±¾È˵ÄÊÇWIN7 X64ϵͳ£¬ÎÒÏÂÔØµÄÊÇAPACHE 2.2.4-win32 x86µÄ·þÎñÆ÷ºÍmysql 5.1.43 ºÍ PHP 5.3µÄ£¬
²»ÖªµÀÄܲ»ÄÜÔÚÎÒµÄϵͳÖÐÔËÐÐÄØ£¿
ËûÃÇÈý¸öÖ®¼äµÄÅäÖÃÄÜÁгöÀ´Âð£¿
Ò»²½Ò»²½µÄ°²×°¶¼Òªà¸£¬±¾ÈËÊDzËÄñ£¬¸ÕѧPHP¹þ£¡
»òÕßÎÒÏÂÔØ´íÎóÁË£¬Çë´ó¼ÒÓÐÔÚWIN7 X64ϵͳµÄ»ù´¡Ï¸øÎÒÖ¸µãÏÂÓ¦¸ÃÒªÏÂÔØÄÄЩºÍÅäÖÃÊÇÔõôÑùµÄ£¡
л ......

½«Excelµ¼ÈëMySQLÊý¾Ý¿â

ÈçÌ⣬
ExcelÓëMySQL±íµÄ×ֶοÉÄܲ»Ò»Ñù¡£
±ÈÈ磬ExcelÓÐ5¸ö×ֶΣ¬MySQLÖ»ÐèÒªÆäÖÐ3¸ö×ֶΡ£
Çë¸÷λÐֵܽãÃÃÌṩºÃµÄ·½·¨»ò½¨Òé¡£

excel µ¼Èëdataset,ÔÙ±éÀú²Ù×÷dataset£¬Ð´ÈëMySQL

лл¥Éϵĸ÷λÐֵܣ¬£¬¿ÉÒÔÏêϸµãÂ𣬣¬£¬°³ÐÂÊÖ

°ÂÅÖµÄÍ·ÏñºÃ¿É°®Å¶
½Ó·Ö¡£¡£¡£
{{ ......

±È½ÏmssqlserverºÍ oracle»¹ÓÐmysqlÖÐÊÓͼ²îÒì

Çë½Ì¸÷λ´óϺ£º
  ¡°±È½ÏmssqlserverºÍ oracle»¹ÓÐmysqlÖÐÊÓͼ²îÒ족£¬
  Ï£Íû¸÷λ²»Òª±£Áô×Ô¼ºµÄÒâ¼û£¡
²»Í¬µÄÊý¾Ý¿â²úÆ·£¬´óÌåÉÏÏàͬ£¬Ï¸½ÚÉϲ»Ò»Ñù£¬Èç¹ûÒªÏêϸ±ÈÆðÀ´£¬¿É²»ÊÇÒ»Á½Ç§×ÖÄÜдÍêµÄ¡£

¾Í±È½ÏÊÓͼ£¬´óÌåÉÏ˵һϾÍÐÐ

ÎÒ×Ô¼ºÌṩһЩ¸ø´ó¼Ò½è¼øÒ»Ï£¬¸Õ²éµ½µÄ
´æ´¢¹ý³Ì
¡¡¡¡ÓÐÈËÖ§³ ......

Mysql¶à±í»¥Áª,²éѯÎÊÌâ.

  ÎÒÔÚAÒ³µÄÁ´½ÓÊÇÒªÏÔʾÔÚBÒ³,¾ÍÊÇ¿çÒ³²éѯµÄ,¼ÓÁ˲ÎÊýID=XXX,¿ÉÊDz»ÖªµÀ,,BÒ³ÄDZßÔõôд,..php+mysql.....Çë´ó¼Ò°ï°ïæ...
ÎÊÌâÃèÊö²»¹»Ïêϸ£¬ÉÁ~


ÎÒͬÒâ2Â¥µÄ˵·¨¡£¡­¡­

лл2Â¥,ÎÒ˵µÄ¾ÍÊÇÕâÒâ˼,,ÎҸ㶨ÁË..лл...
......
×ܼǼÊý:1662; ×ÜÒ³Êý:277; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [40] [41] [42] [43] 44 [45] [46] [47] [48] [49]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ