MySQLµÄ ¸÷°æ±¾Çø±ð
µÚÒ»¸ö MySQL Community Server£¬Õâ¸ö²»ÒªÇ®£¡
µÚ¶þ¸ö MySQL Enterprise Õâ¸öÒªÌÍÇ®£¬²»¹ý¿ÉÒÔ´òµç»°×ÉѯÎÊÌ⣬Ҳ¾ÍÊǵ绰¼¼ÊõÖ§³Ö¡£
µÚÈý¸ö MySQL Cluster£¬Õâ¸öµ¥¶ÀÊÇû·¨Óõģ¬ÒªÔÚ1»ò2µÄ»ù´¡ÉÏÓᣵ±È»ÓÃÀ´Æ½ºâ¶ą̀Êý¾Ý¿âµÄ¡£
µÚËĸö MySQL Workbench£¬ÕâÊǸöºÃ¶«Î÷£¬ÓÃÀ´Éè¼ÆÊý¾Ý¿âµÄ¡£erwinÖªµÀÂð£¿Ëû¾ÍÊÇÕâ¸ö×÷Óá£
MySQL Community Server ÉçÇø°æ±¾ Ó¦¸Ã²»Ìṩ¹Ù·½¼¼ÊõÖ§³Ö
MySQL Enterprise Server MySQLÆóÒµ°æ·þÎñÆ÷
Èí¼þÊÇ×î¿É¿¿¡¢×ȫ¡¢¸üа汾µÄMySQLÆóÒµ¼¶·þÎñÆ÷Êý¾Ý¿â£¬ËüÄܹ»¸ßÐԼ۱ȵØÌṩµç×ÓÉÌÎñ¡¢Áª»úÊÂÎñ´¦Àí(OLTP)¡¢Ç§Õ×¹æÄ£µÄÊý¾Ý²Ö¿âÓ¦Óõȡ£ËüÖ§³ÖACIDÊÂÎñ´¦Àí£¬ÄÜÌṩÍêÕûµÄÌá½»¡¢»Ø¹ö¡¢±ÀÀ£»Ö¸´ºÍÐм¶Ëø¶¨¹¦ÄÜ¡£MySQLÊý¾Ý¿âÒòÆäÒ×ÓÃÐÔ¡¢¿ÉÀ©Õ¹ÐԺ͸ßÐÔÄܵÈÌص㣬³ÉΪȫÇò×îÁ÷ÐеĿªÔ´Êý¾Ý¿â¡£
MySQL Cluster 2̨ÒÔÉÏ mysql¼¯Èº·þÎñÆ÷
MySQL WorkbenchÓÐÁ½¸ö°æ±¾£º
MySQL Workbench Community Edition£¨ÓÖ½ÐMySQL Workbench OSS£¬ÉçÇø°æ£©ºÍMySQL Workbench Standard Edition£¨ÓÖ½ÐMySQL Workbench SE£¬ÉÌÒµ°æ£©¡£MySQL Workbench OSSÊÇÔÚGPLÖ¤ÊéÏ·¢²¼µÄ¿ªÔ´ÉçÇø°æ±¾£¬¶øMySQL Workbench SEÔòÊÇ°´ÄêÊշѵÄÉÌÒµ°æ±¾¡£Æ书ÄÜ·½ÃæµÄ²îÒì¼ûÏÂ±í£¨²»µÃ²»Ëµ£¬Êý¾Ý¿â/Ä£ÐÍͬ²½ÕâÒ»ÖØÒªµÄ¹¦Äܾ¹È»Ö»ÔÚÊշѵÄMySQL Workbench SEÖпÉÓ㬶øÔÚDBDesigner4ÖÐÕâÈ´ÊÇ»ù±¾¹¦ÄÜ£¬ÕâÖÖ“¼ÌÈΔ·½Ê½ÊµÔÚÈÃÈ˶ñÐÄ);
²¹³ä:
.tgzÊÇÔ´Âë°²×°£¬
glibcÊÇÖ¸C±àÒëÆ÷µÄ°æ±¾ÁË¡£
Essentials ¾«¼ò - È¥³ýÁËʵÀýÎļþ
"noinstall.zip”µÄÊÇ˵¸ÃѹËõ°üÀïÃæµÄÎļþÊDz»Óð²×°µÄ£¬Ö±½ÓʹÓá£
------------------------------------------------------------------------------------------------------------------------------
MySQL-3.23.39-1.i386.rpm £º°üº¬ÔËÐÐMySQL·þÎñÆ÷ËùÐèµÄÈ«²¿Îļþ£¬°üÀ¨¿Í»§»ú³ÌÐò
MySQL-3.23.39-1.src.rpm£º°üº¬MySQLµÄËùÓÐÔ´Âë
MySQL-bench-3.23.39-1.i386.rpm£º°üº¬ÓÃÓÚ²âÊÔMySQLÐÔÄܵijÌÐò£¬ ÕâЩ²âÊÔ³ÌÐòÐèÒªÖ÷·¢ÐеµºÍPerl
MySQL-client-3.23.39-1.i386.rpm£ºÖ»°üº¬¿Í»§»ú³ÌÐò
MySQL-devel-3.23.39-1.i386.rpm“£º°üº¬±àÒë¿Í»§»ú³ÌÐòËùÐèÒªµÄ¿âºÍÍ·Îļþ
MySQL-shared-3.23.39-1.i386.rpm£º°üº¬ÓÃÓÚ¿Í»§»ú³ÌÐòµÄ¹²Ïí¿â
¹ØÓÚϵͳ°æ±¾£º
Windows Essentials (x86) 6.0.7 £ºEssentials ¾«¼ò£¬¾«¼ò°æ - È¥³ýÁËʵÀýÎļþ
Windows ZIP/Setup.EXE (x86) 6.0.7£º×Ô¶¯°²×°°æ£¬ÏÂÔØÏÂ
Ïà¹ØÎĵµ£º
1Â¥
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§ÃûÇ°¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëÇ°±ØÐëÃ»Ó ......
¶ÔÓÚÿ¸öÀàÐÍÓµÓеÄÖµ·¶Î§ÒÔ¼°²¢ÇÒÖ¸¶¨ÈÕÆÚºÎʱ¼äÖµµÄÓÐЧ¸ñʽµÄÃèÊö¼û7.3.6 ÈÕÆÚºÍʱ¼äÀàÐÍ¡£
ÕâÀïÊÇÒ»¸öʹÓÃÈÕÆÚº¯ÊýµÄÀý×Ó¡£ÏÂÃæµÄ²éѯѡÔñÁËËùÓмǼ£¬Æädate_colµÄÖµÊÇÔÚ×îºó30ÌìÒÔÄÚ£º
mysql> SELECT something from table
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) select DAYOFWEEK('1998-02-03');
-&g ......
#include "winsock.h"
#include "mysql.h"
void query_example(void)
{
MYSQL *pDbCon = NULL;
char *pszHost = "localhost";
char *pszUser = "guest";
char *pszPsw = "";
char *pszDbName = "mysql_db_name";
int iPort = 3306;
pDbCon = mysql_init((MYSQL*) 0);
if (NULL != pDbCon)
{
......
Ê×ÏÈ£ºÈ·¶¨Êý¾Ý¿âµÄ±àÂëΪutf8£¬Õý³£´¢´æÖÐÎÄ£¨ÓÃMySQL-Front²é¿´ÖÐÎÄÊÇ·ñÕý³££©
È»ºó£ºServices²éѯMySQLʱʹÓÃ"SET NAMES 'utf8'"£¬ÇÒͨ¹ý"amfphp/browser"ÔËÐп´¿´ÊÇ·ñÖÐÎÄ£¬Èç¹ûÂÒÂëÔòÐÞ¸Ägateway.phpÎļþ£¬È¥µô $gateway->setCharsetHandler("utf8_decode", "ISO-8859-1", "ISO-8859-1");
×îºó£ºÔËÐÐFlex³ÌÐòÏÔ ......