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%"; ºÃÏñ²»ÐÐ
{{
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
mysqlÖÐÓм¸¸ö×Ö¶Î
id
name
img(ÒÔ¶þ½øÖƵķ½Ê½´æÈëmysqlÖÐ)
ÎÒÄܹ»µ¥¶À¶ÁȡͼƬ(Ö»ÄܶÁÈ¡ÆäÖÐÒ»¸öͼƬ)
µ«Êǵ±ÎÒ°ÑËùÓÐÐÅÏ¢¶¼·Åµ½requestÖеÄʱºò
ͼƬÄܶÁÈ¡³öÀ´µ«ÊÇÆäËû¶«Î÷£¨name,id£©È´¶Á²»³öÀ´
(
¶ÁÈ¡ ......