mysqlÃüÁîÐпͻ§¶ËÏÔʾÂÒÂë
mysqlÃüÁîÐпͻ§¶ËÏÔʾÂÒÂë
mysql> select * from userinfo;
+--------+----------+----------+------+-----------+-----------+
| autoid | username | password | sex | realname | qq |
+--------+----------+----------+------+-----------+-----------+
| 1 | xiaoqing | 1234 | 鐢? | xiaoxiao | 569823 |
| 2 | boys | 123 | å¥? | æ¢侀綈鐑? | 395423086 |
| 3 | xiao7 | xiao7520 | 鐢? | 鍛µå懙 | 鍛µå懙 |
+--------+----------+----------+------+-----------+-----------+
µ«ÊÇÎÒÓÿÉÊÓ»¯µÄÈí¼þ EMS SQL Manager 2005 Lite for MySQL
¿´µ½µÄÊý¾ÝÈ´ÄÜÕýÈ·ÏÔʾÖÐÎÄ
ÇëÎÊÕâ¸öÎÊÌâÈçºÎ½â¾ö?Çë¸ßÊִͽÌ.
×Ö·û¼¯µÄÎÊÌ⣬Èç¹ûÊÇ gb2312 / gbk Ôò set names һϾÍÐÐÁË£¬Èç¹ûÊÇUTF8£¬ÔòÄãµÄDOS²»Ö§³ÖUTF8´ÓMYSQLÖÐÏÔʾ¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
set names gbk;¾Í¿ÉÒÔ¡£(¸Ä±ä¿Í»§¶Ë±àÂë)
SQL code:
mysql> show variables like "%char%";
+--------------------------+------------------------------------------
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÈÕIPÊýǧ ÒÔºó»áÉÏÍò Ò²ÊÇflex+javaÓÎÏ·ÀàÐ͵ÄÍøÕ¾ ¼¯ÖÐÔڸ߷åÆÚÍíÉÏ
ÇëÎÊÊý¾Ý¿â·þÎñÆ÷µÄ»úÆ÷ÓÃʲôƷÅƺã¿ÍƼöÒ»¸öÅäÖã¿
ÏÖÔÚÊý¾Ý¿âÊÇʹÓÃmysql5.0 ÊDz»ÊÇÊʺϣ¿ ¸Ã²»¸Ã»»³ÉOralce(ÏÖÔÚ»»»¹ ......
±¾ÈËÐÂÊÖ ÏÂÔØÁ˸ömysql ÇëÎÊÈçºÎ°²×°
mysql-5.1.32-linux-i686-glibc23.tar.gz
ÄãÊÇʲôϵͳ£¿
redhatµÄ»°¾ÍÈ¥ÏÂrpm£¬Ö±½Órpm -i xxxx.rpm¾ÍOKÁË
²»¹ý±¾ÈË»¹ÊÇÍƼöʹÓð²×°µÄ°æ±¾
ÒýÓÃ
ÎÒ¿´Á ......