Mysql²éѯʱ£¬¶ÔÓÚÊýÖµÐÍ×ֶμӵ¥ÒýºÅ»áÒýÆðµÄÎó½â¡«
¼ÙÉèÓбí tb1
ID £ü name£ü
----+--------+
1 £ü2toon£ü
2 £ü1*xyz£ü
Óï¾ä1£º
select * from tb1 where ID='2toon' or name ='2toon';
mysql·þÎñÆ÷ÔÚijģʽÏ£¬¿ÉÒÔÖ´ÐÐÕâÌõ¾ä£¬¾Í³É¹¦·µ»ØÁ½Ìõ¼Ç¼£¬ÔÒòÔÚÓÚ ID=‘2toon’ ¼ÓÁ˵¥ÒýºÅ£¬mysql½âÊÍΪ ID=2.
Óï¾ä2
select * from tb1 where ID=2toon or name ='2toon';
´ËÓï¾äÖ´Ðв»ÁË¡£
Òò´Ë£¬ÏëÒªµÃ׼ȷµÄ²éѯ½á¹û£¬¶ÔintµÄ×Ö¶ÎÒ»¶¨Òª×öÅжÏÓëתÀàÐÍ¡£
תÀàÐÍ»¹¿ÉÒÔ·ÀÖ¹SQL×¢Èë¡£
Ïà¹ØÎĵµ£º
1.reverse(str)º¯Êý: ·µ»Øµßµ¹×Ö·û˳ÐòµÄ×Ö·û´®str, ¸Ãº¯Êý¶Ô¶à×Ö½Ú¿É¿¿µÄ.
mysql> select * from user;
+----+------------------+
| id | name |
+----+------------------+
| 1 | test &nbs ......
(1)°²×° freeradius-server-2.1.1.tar.gz
[root@localhost freeradius-server-2.1.1]# tar zxvf freeradius-server-2.1.1.tar.gz
[root@localhost freeradius-server-2.1.1]# cd freeradius-server-2.1.1
[root@localhost freeradius-server-2.1.1]# ./configure
[root@localhost freeradius-server-2.1.1]# make
[ ......
ÒòΪMySQLÔÙdebianÏÂĬÈÏÊDz»ÔÊÐíÔ¶³ÌÁ¬½ÓµÄ£¬ËùÒÔÐèҪעÊ͵ôÕâ¸öÏÞÖÆ¡£ÎÒµÄMySQLÊÇÓÃapt-get°²×°µÄ£¬ËùÒÔ·¾¶ÊÇĬÈϵģ¨Èç¹ûÊÇ×Ô¼º
ÊÖ¶¯°²×°£¬¿ÉÒÔ×Ô¼ºÑ°ÕÒÏÂÕýÈ·µÄ·¾¶£©£¬ÓÃÃüÁî vi /etc/mysql/my.cnf ´ò¿ªÎļþ£¬×¢Ê͵ô bind-address = 127.0.0.1 ±£´æ:wq »Ø³µ¡£
È»ºóÔٵǼµ½MySQL·þÎñÆ÷¶Ë£¬ÔÚmysql¿âÏÂÖ ......
netbeans6.7ÖÐÏòmysql5ÖвåÈëÖÐÎÄÊý¾ÝʱÏÔʾ”data too long for column“µÄÎÊÌâ¡£
ÎÒµÄmysqlÖÐ×Ö·ûµÄÉèÖÃʱutf-8£¬²¢ÇÒÔÚ¿ØÖÆÌ¨ÖпÉÒÔ²åÈëÖÐÎÄÊý¾Ý²¢ÏÔʾ£¬µ«ÔÚnetbeansÖвåÈëÊý¾Ýʱȴ×ÜÊÇÏÔʾ”data too long for column“¡£»ù±¾¿ÉÒÔÅжÏÊÇÓÉÓÚnetbeansºÍmysqlÖ®¼äµÄÊý¾Ý½»»»³öÁ ......