cobar and mysql·Ö¿â×Ö¶ÎÎÊÌâ
½ñÌìµ÷³ÌÐò´ÓÊý¾Ý¿âÀïÈ¡Êý¾Ý£¬Ò»Ö±È¥²»³öÀ´£¬°ÑÈÕÖ¾Àï´ò³öÀ´µÄsql·Åµ½Êý¾Ý¿âÀïÈ¥Ö´ÐУ¬È´ÓÖÄÜ
È¡³öÊý¾ÝÀ´£¬ºÜÊÇÓôÃÆ¡£
Êý¾Ý¿âÊÇmysqlµÄ£¬Ò»¹²128¸ö¿â£¬Í¨¹ýij¸ö×ֶηֿ⡣
ºóÀ´·¢ÏÖÒª²éµÄÕâÌõÊý¾ÝµÄ·Ö¿â×ֶα»¸Ä¹ý£¬°´ÕÕ³ÌÐòÀïÖ´ÐеÄÈ¥²é£¬Ëû¾ÍÈ¥ÁËÁíÍâÒ»¸ö¿âÈ¥²éѯÁË£¨ÒòΪ·Ö¿â×ֶα»¸Ä¹ý£©
¶øÖ±½ÓÈ¥Êý¾Ý¿âÀïÈ¥²é£¬²éѯÁËËùÓеĿ⣬ËùÒÔÄܲé³öÊý¾ÝÀ´¡£
°´ÕÕcobarµÄÔÔò£¬²éѯÌõ¼þ´øË«ÒýºÅÊÇĬÈϲéËùÓеĿ⣬¶øµ¥ÒýºÅÊÇ°´ÕÕ·Ö¿â×Ö¶ÎÈ¥²éÏàÓ¦µÄ¿â¡£
±ÈÈ磺
1.²éËùÓеĿ⣺ select * from A where b="test"
2.²éµ¥¿â£º select * from A where b='test' and ·Ö¿â×Ö¶Î='cobar'
Ïà¹ØÎĵµ£º
£¨1£©Æô¶¯
MySQL°²×°Íê³ÉºóÆô¶¯ÎļþmysqlÔÚ/etc/init.dĿ¼Ï£¬ÔÚÐèÒªÆô¶¯MySQL·þÎñʱÔËÐÐÏÂÃæÃüÁî¼´¿É¡£ [root@test1 init.d]# /etc/init.d/mysql start
£¨2£©Í£Ö¹
/usr/bin/mysqladmin -u root -p shutdown
£¨3£©ÉèÖÃMySQL×Ô¶¯Æô¶¯
1£©²ì¿´mysqlÊÇ·ñÔÚ×Ô¶ ......
ÎÊÌâ½â¾öÁË£¬ÔÒòÊÇÔÚmy.cnfÖÐȱÉÙÁËÈçÏ´úÂ룺
[client]
default-character-set=utf8
[mysqld]
default-character-set=utf8
Èç¹û²»¼ÓÒÔÉÏ´úÂ룬ÄÇô¼´±ãMYSQL±àÒ밲װʱָ¶¨µÄ±àÂëÊÇUTF8£¬ÄÇôÔÚ½¨¿âʱÆäĬÈϱàÂëÈÔÊÇLATIN1£¬¶øÓÉÓÚ×Ö·û¼¯µÄ¼Ì³ÐÐÔ£¬¿âÖеıíÒ²ÊÇLATIN1µÄÁË¡£
ÕâÀïÁм¸ÌõÃüÁ´ó¼Ò¿ÉÒÔ×Ô¼ºÊÔÏ ......
http://www.ej38.com/showinfo/mysql-130795.html
CentOSÏÂMysqlʵÏÖÊý¾Ý¿âÖ÷´Óͬ²½
Ò»¡¢»·¾³
¡¡¡¡A·þÎñÆ÷£º 192.168.10.42 Ö÷·þÎñÆ÷master¡¡¡¡CentOS 5¡¡¡¡Mysql 5.1.34
¡¡¡¡B·þÎñÆ÷£º 192.168.10.68 ¸±·þÎñÆ÷slave¡¡¡¡¡¡CentOS 5¡¡¡¡Mysql 5.0.56
¶þ¡¢ÉèÖÃMas ......
ÎÊÌ⣺һ¿ªÊ¼ÎÒÓÃNavicat Lite for mysql ½«Êý¾Ý¿âת´æ´¢Î»sqlÎļþ¡£´ò¿ªÖ®ºó·¢ÏÖ£¬ÖÐÎĶ¼±ä³ÉÁËÂÒÂë¡£
ËùÒÔ ÔÚÍøÉÏËÑË÷ÁËЩ×ÊÁÏ¿´¿´¡£·¢¾õ´ó¼Ò¶¼ÊÇÓÃÃüÁîµ¼³öµÄ¡£ÓÃÁËÖ®ºó£¬ÖÐÎľͲ»ÂÒÂëÁË¡£½â¾öÁËÎÒµÄÒ»¸öÄÑÌâ¡£Ìش˼ÇÏ¡£
·½·¨:
Ê×ÏÈÈ·ÈÏ mysql·þÎñÊÇ¿ªÆôµÄ¡£
È»ºóµã“¿ªÊ¼”ÔËÐÐÊäÈëcmd£¬½øÈëDOS»·¾³¡£cd ......
MYSQL Castº¯Êý ÀàÐÍת»»
BINARY
BINARY²Ù×÷·û½«ºóÃæµÄ×Ö·û´®Å׸øÒ»¸ö¶þ½øÖÆ×Ö·û´®¡£ÕâÊÇÒ»ÖÖ¼òµ¥µÄ·½Ê½À´´ÙʹÖð×Ö½Ú¶ø²»ÊÇÖð×Ö·ûµÄ½øÐÐÁбȽϡ£ÕâʹµÃ±È½ÏÇø·Ö´óСд£¬¼´Ê¹¸ÃÁв»±»¶¨ÒåΪ BINARY»ò BLOB¡£BINARYÒ²»á²úÉú½áβ¿Õ°×£¬´Ó¶ø¸ü¼ÓÏÔÑÛ¡£
mysql> SELECT 'a' = 'A';
-> 1
mysql> SELECT BINARY ' ......