mysqlĿǰ°æ±¾
´ó¼ÒÏÖÔÚÓõÄmysql°æ±¾¶¼ÊÇ Äĸö£¿ ±È½ÏÎȶ¨µÄ£¿
SQL code:
mysql> select @@version;
+----------------------+
| @@version |
+----------------------+
| 5.1.37-community-log |
+----------------------+
http://dev.mysql.com/downloads/
mysql 5.1.42
5.0Óë5.1ÔÚÓÅ»¯ÉÏÓÐÊ²Ã´Çø±ð£¿»òÕßÊÇÓ¦¸Ã×¢ÒâµÄµØ·½Ã´£¿
ÏÖÔÚ·¢²¼µÄ×îаæÊÇ 5.1.42
ÏÖÔÚ·¢²¼µÄ×îаæÊÇ 5.1.42
5.1 ±È 5.0 ¶àÁË
Event scheduler
Partitioning
Pluggable storage engine API
Plugin API
Row-based replication
Server log tables
Row-based replication £¿
ÎÒÓÃ5.1Ôõôû¸Ð¾õµ½£¿slaveµÄºǫ́×ÜÊÇÓÉsystem userÖ´ÐÐinsert,delete»òupdateµÄÓï¾ä£¡
Row-based replication
ÄãÒª°ÑÄãµÄBINLOGÉèÖÃΪROW-BASED¡£µ±È»ÕâÑù»áµ¼ÖÂBINLOG»áºÜ´ó¡£
ÎÒÓÃ5.0£¬ÔÚubuntuÕÒ²»µ½´ò°üºÃµÄ5.1°æ±¾
SQL code:
+-------------------
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
ÔÌûÇë¿´
http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601
×ܽáϾÍÊÇ
apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......