mysql and or ?
Çó֤һϣº
¿ÉÒÔÈçÏÂÕâÑù²Ù×÷ô£¿ÎÒÊÔÁË¿ÉÒÔÂú×㣬µ«»¹ÊÇÇó֤һϡ£
SELECT * from test where name='zhangsan' and (xingbie='nan' or mianling='30') and (yuyan='en' or haoma='123')
ÊǹØÓÚÒ»¸ö¶àÏî²éѯµÄÎÊ´ð£¡
ÇëÎÊÕâÑù¿ÉÒÔô£¿ and ( or or ) and ( or or or ) and ( or or or or ) {{--
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
bas_car ±í ÓÐÁÐcarname £¬Òª½øÐÐÊý¾Ýͳ¼Æ£¬
select count(a.carname),a.carname from bas_car a,bas_car b where a.carid>=b.carid and a.carname=b.carname
group by a.carname
ÈçÉϲéѯ½á ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
ÎÒÔÚubuntuÏ´îÅäÀïphp»·¾³£¬¿ÉÊÇÀïÃæµÄ±àÂëÎÊÌâ¿ì°ÑÎұƷèÁË¡£
Ï£Íû¸ßÊÖÄܰïÎÒ½â¾ö¡£Ð»ÁË¡£¡£¡£
ÎÒµÄmysql×Ö·ûÉèÖÃÈçÏ£º
mysql> show variables like 'character%';
+--------------------------+--------- ......