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£º×Ô¶¯°²×°°æ£¬ÏÂÔØÏÂ
Ïà¹ØÎĵµ£º
¡¡Ò»Ö±À§ÈÅÎÒ¿ì°ëÄêµÄÎÊÌâÖÕÓڵõ½½â¾ö, ·þÎñÆ÷µÄmysqlÀÏÊÇÔËÐÐÒ»¶Îʱ¼ä,×Ô¶¯Í£Ö¹ÁË,±ØÐëÊÖ¶¯Æô¶¯. !
¡¡¡¡ÎÒÕÒÆ«ÍøÉÏËùÓеķ½·¨,µ«Ã»ÓÐÒ»¸öÄܽâ¾ö,ʲôÐÞ¸ÄÅäÖÃÎļþ°¡.¶¨Ê±Æô¶¯.¶¼Ã»Ð§¹û. ¸ù¾Ýר¼Ò¹Û²ì£¬ÕâÑùµÄÀíÂÛºÍÏÖÏó¶¼ÊÇÖµµÃ¸÷λվ³¤Éî˼µÄ£¬ËùÒÔÏ£Íû´ó¼Ò¶à×öÑо¿Ñ§Ï°£¬ÕùÈ¡×ܽá³ö¸ü¶à¸üºÃµÄ¾Ñé!
¡¡¡¡Õâ¸ö·½·¨ÊÇÎÒ ......
#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)
{
......
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿â
ÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØÖ·£ºhttp://sourceforge.net/projects/mysqldrivercs/ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½MySQLDriver.dll£¬È»ºó½«MySQLDriver.dllÌí¼ÓÒýÓõ½ÏîÄ¿ÖÐ×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe using System;using System.Collectio ......
Ô¶³ÌµÇ¼ -h IPµØÖ·
ctrl + d Í˳ö »ò \q »ò quit
select version(); µ±Ç°°æ±¾
current_dateµ±Ç°ÈÕÆÚ »òcurdate() »ò current_date()
SELECT name, birth, curdate(),(year(curdate())-year(birth)) - (right(curdate(),5)<right(birth,5)) as age from ±í ORDER BY name;
year ÌáÈ¡Ä겿·Ö right(curdate(),5)ÌáÈ¡Ó ......