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%"; ºÃÏñ²»ÐÐ
{{ ......
Èý¸öÎÊÌ⣺
£¨1£©ÊµÏÖ JAVA·ÃÎÊmySqlÊý¾Ý¿â¡£¡£
¿ÉÒÔ¸ø³öʵÀý´úÂëÂð£¿
°³Ö»»á.NET,
ÒªÇóÔÚJ2EE»·¾³ÏÂÔõôʵÏÖ£¿
£¨2£©JAVA·ÃÎÊmySqlÊý¾Ý¿âÒª²»ÒªÇý¶¯£¿
£¨3£©EclipseÓÐwebserviceÂð£¿
¿ÏÇó¸÷λÐֵܽãÃ㬸ø³öʵÀý´úÂ룡¸Ð¼¤²»¾¡¡£¡£
ÎÊÌâ1:ÓÃJDBC·ÃÎÊ ......
±¾È˵ÄÊÇWIN7 X64ϵͳ£¬ÎÒÏÂÔØµÄÊÇAPACHE 2.2.4-win32 x86µÄ·þÎñÆ÷ºÍmysql 5.1.43 ºÍ PHP 5.3µÄ£¬
²»ÖªµÀÄܲ»ÄÜÔÚÎÒµÄϵͳÖÐÔËÐÐÄØ£¿
ËûÃÇÈý¸öÖ®¼äµÄÅäÖÃÄÜÁгöÀ´Âð£¿
Ò»²½Ò»²½µÄ°²×°¶¼Òªà¸£¬±¾ÈËÊDzËÄñ£¬¸ÕѧPHP¹þ£¡
»òÕßÎÒÏÂÔØ´íÎóÁË£¬Çë´ó¼ÒÓÐÔÚWIN7 X64ϵͳµÄ»ù´¡Ï¸øÎÒÖ¸µãÏÂÓ¦¸ÃÒªÏÂÔØÄÄЩºÍÅäÖÃÊÇÔõôÑùµÄ£¡
л ......
ÈçÌ⣬
ExcelÓëMySQL±íµÄ×ֶοÉÄܲ»Ò»Ñù¡£
±ÈÈ磬ExcelÓÐ5¸ö×ֶΣ¬MySQLÖ»ÐèÒªÆäÖÐ3¸ö×ֶΡ£
Çë¸÷λÐֵܽãÃÃÌṩºÃµÄ·½·¨»ò½¨Òé¡£
excel µ¼Èëdataset,ÔÙ±éÀú²Ù×÷dataset£¬Ð´ÈëMySQL
лл¥Éϵĸ÷λÐֵܣ¬£¬¿ÉÒÔÏêϸµãÂ𣬣¬£¬°³ÐÂÊÖ
°ÂÅÖµÄÍ·ÏñºÃ¿É°®Å¶
½Ó·Ö¡£¡£¡£
{{ ......
Çë½Ì¸÷λ´óϺ£º
¡°±È½ÏmssqlserverºÍ oracle»¹ÓÐmysqlÖÐÊÓͼ²îÒ족£¬
Ï£Íû¸÷λ²»Òª±£Áô×Ô¼ºµÄÒâ¼û£¡
²»Í¬µÄÊý¾Ý¿â²úÆ·£¬´óÌåÉÏÏàͬ£¬Ï¸½ÚÉϲ»Ò»Ñù£¬Èç¹ûÒªÏêϸ±ÈÆðÀ´£¬¿É²»ÊÇÒ»Á½Ç§×ÖÄÜдÍêµÄ¡£
¾Í±È½ÏÊÓͼ£¬´óÌåÉÏ˵һϾÍÐÐ
ÎÒ×Ô¼ºÌṩһЩ¸ø´ó¼Ò½è¼øÒ»Ï£¬¸Õ²éµ½µÄ
´æ´¢¹ý³Ì
¡¡¡¡ÓÐÈËÖ§³ ......
ÎÒÔÚAÒ³µÄÁ´½ÓÊÇÒªÏÔʾÔÚBÒ³,¾ÍÊÇ¿çÒ³²éѯµÄ,¼ÓÁ˲ÎÊýID=XXX,¿ÉÊDz»ÖªµÀ,,BÒ³ÄDZßÔõôд,..php+mysql.....Çë´ó¼Ò°ï°ïæ...
ÎÊÌâÃèÊö²»¹»Ïêϸ£¬ÉÁ~
ÎÒͬÒâ2Â¥µÄ˵·¨¡£¡¡
лл2Â¥,ÎÒ˵µÄ¾ÍÊÇÕâÒâ˼,,ÎҸ㶨ÁË..лл...
......