Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¾ßÓиºÔؾùºâ¹¦ÄÜMySQL·þÎñÆ÷¼¯Èº²¿ÊðʵÏÖ

À´×Ô£ºhttp://it.china-b.com/zx/linuxsjk/20090525/24129_1.html
ÕªÒª£ºMySQLÊÇÒ»¸ö¸ßËÙ¶È¡¢¸ßÐÔÄÜ¡¢¶àÏ̵߳ĹØÏµÐÍÊý¾Ý¿â
ÖÎÀíϵͳ£¬ÊÊÓÃÆ½Ì¨¶à£¬¿ÉÀ©Õ¹ÐÔÇ¿¡£ÔÚʵ¼ÊÉú²ú»·¾³ÖУ¬²¿ÊðºÍʵÏÖ¾ßÓÐÒ»¶¨¸ºÔؾùºâ¹¦ÄܵÄMySQL·þÎñÆ÷¼¯Èº£¬¶ÔÓÚÌá¸ßÓû§Êý¾Ý¿â
Ó¦ÓÃϵͳµÄÐÔÄÜ¡¢ËٶȺÍÎȶ¨ÐÔ¾ßÓÐÃ÷ÏÔµÄ×÷Óᣱ¾ÎļòÒª½éÉÜÁËÔÚFreeBSD 7.0-ReleaseϵͳÉϲ¿ÊðʵÏÖMySQL·þÎñÆ÷¼¯ÈºµÄ·½°¸£¬²¢¶Ô¿ÉÄܳöÏÖµÄÎÊÌâÌṩÁËÏàÓ¦µÄ½â¾ö·½·¨¡£
1. ÒýÑÔ
MySQLÊÇÒ»¸ö¸ßËÙ¶È¡¢¸ßÐÔÄÜ¡¢¶àÏ̡߳¢¿ª·ÅÔ´´úÂ룬½¨Á¢ÔÚ¿Í»§/·þÎñÆ÷½á¹¹ÉϵĹØÏµÐÍÊý¾Ý¿â
ÖÎÀíϵͳ¡£ËüʼÓÚ1979Ä꣬×î³õÊÇMichael WideniusΪÈðµäTcX¹«Ë¾´´½¨µÄUNIREGÊý¾Ý¿â
ϵ
ͳ£¬µ±Ê±µÄUNIREGûÓÐSQL½Ó¿Ú£¬ÏÞÖÆÁËËüµÄÓ¦Óá£1996Äê5Ô£¬Widenius¿ª·¢³öÁËMySQLµÄ×î³õ°æ±¾£¬¿ªÊ¼ÔÚInternetÉϹ«¿ª
·¢ÐС£MySQLµÄ¿ª·¢ÈËÔ±´ÓÒ»¿ªÊ¼¾ÍÒ»Ö±¹Ø×¢ËüµÄÐÔÄÜ£¬Îª´Ë²»Ï§ÌØÐÔ¼¯£¬Ö±µ½½ñÌ죬MySQLÒÀÈ»±£³Ö±¾É«£¬ÒÔ¸ßËٶȸßÐÔÄÜΪÊ×ÒªÔ­Ôò¡£Ëæ×Åʱ¼äµÄÍÆ
ÒÆ£¬MySQLÒ²¼ÓÈëÁË´óÐÍÊý¾Ý¿â
²úÆ·µÄ¸ß¼¶ÌØÐÔ£¬Èç´æ´¢¹ý³Ì¡¢ÊÓͼ¡¢´¥·¢Æ÷µÈ£¬Ê¹ÆäÔÚÆóÒµ¼¶Êý¾Ý¿â
ϵͳÖпªÊ¼±»²¿ÊðÓ¦Óá£2008Äê10Ô£¬SUN¹«Ë¾ÊÕ¹ºÁËMySQL AB¹«Ë¾£¬¿ªÊ¼½øÈ뿪ԴÁìÓò¡£Ëæ×ÅÖØÁ¿¼¶²Ù×÷ϵͳSolarisµÄ¿ªÔ´£¬SUN MySQLÔÚÊý¾Ý¿â
Êг¡Õ¼Óеķݶ»á½øÒ»²½Ìá¸ß¡£Òò´Ë£¬ÔÚÉú²ú»·¾³Öв¿Êð¾ßÓиºÔؾùºâ¹¦ÄܵÄMySQL·þÎñÆ÷¼¯Èº£¬¶ÔÓÚÌá¸ßÆóÒµÊý¾Ý¿â
Ó¦ÓÃϵͳµÄËÙ¶È¡¢Îȶ¨ÐÔ¼°¿ÉÉìËõÐÔ¾ßÓкܴóµÄÏÖʵÒâÒ壬Ҳ¿ÉÒÔÓÐЧ½µµÍÓ¦ÓÃϵͳµÄͶ×ʳɱ¾¡£±¾ÎĽ«ÒÔFreeBSD 7.0-Release²Ù×÷ϵͳΪÀý£¬ÀûÓÃMySQLÊý¾Ý¿â
µÄ¸´ÖÆÌØÐÔ£¬¼òÒª½éÉܲ¿ÊðMySQL·þÎñÆ÷¼¯ÈºµÄʵÏÖ·½·¨ºÍÏà¹Ø×¢ÖØÊÂÏî¡£
¡¡¡¡2. ϵͳģÐÍ
±¾¼¯ÈºµÄ½á¹¹ÎªÒ»¸öÖ÷MySQL·þÎñÆ÷·þÎñÆ÷Óë¶à¸ö´ÓÊôMySQL·þÎñÆ÷½¨Á¢¸´ÖÆÁ¬½Ó£¬Ö÷·þÎñÆ÷Óë´ÓÊô·þÎñÆ÷ʵÏÖÒ»¶¨³Ì¶ÈÉϵÄÊý¾Ýͬ²½£¬¶à¸ö´ÓÊô·þÎñÆ÷´æ´¢ÏàͬµÄÊý¾Ý¸±±¾£¬ÊµÏÖÊý¾ÝÈßÓ࣬ÌṩÈÝ´í¹¦ÄÜ¡£²¿Ê𿪷¢Ó¦ÓÃϵͳʱ£¬¶ÔÊý¾Ý¿â
²Ù×÷´úÂë½øÐÐÓÅ»¯£¬½«Ð´²Ù×÷¶¨Ïòµ½Ö÷·þÎñÆ÷£¬°Ñ´óÁ¿µÄ²éѯ²Ù×÷¶¨Ïòµ½´ÓÊô·þÎñÆ÷£¬ÊµÏÖ¼¯ÈºµÄ¸ºÔؾùºâ¹¦ÄÜ¡£¼ÙÈçÖ÷·þÎñÆ÷·¢Éú¹ÊÕÏ£¬´ÓÊô·þÎñÆ÷½«×ª»»½ÇÉ«³ÉΪÖ÷·þÎñÆ÷£¬Ê¹Ó¦ÓÃϵͳΪÖÕ¶ËÓû§Ìṩ²»¼ä¶ÏµÄÍøÂç·þÎñ;Ö÷·þÎñÆ÷»Ö¸´ÔËÐк󣬽«Æäת»»Îª´ÓÊô·þÎñÆ÷£¬´æ´¢Êý¾Ý¿â
¸±±¾£¬¼ÌÐø¶ÔÖÕ¶ËÓû§ÌṩÊý¾Ý²éѯ¼ìË÷·þÎñ¡£
3. ²¿ÊðʵÏÖ
±¾ÎÄÒÔһ̨Ö÷·þÎñÆ÷´øÈý̨´ÓÊô·þÎñÆ÷ΪÀý£¬¼òÒª½éÉÜMySQL·þÎñÆ÷¼¯ÈºµÄʵÏÖ·½°¸ºÍ¾ßÌå·½·¨²½Öè¡£
3.1 ϵͳ²¿


Ïà¹ØÎĵµ£º

MySQL½«»áÏñBSD¡¢LinuxÄÇÑùŪ³ö²»Í¬µÄ·ÖÖ§ºÍ·¢Ðа棿

    ´ÓÓû§µÄ½Ç¶È¿´£¬MySQL±»SunÊÕ¹º£¬ÓÖ±»OracleÊÕ¹º¿ÉÄÜÕæ²»ÊÇʲôºÃÊ¡£MySQL±¾À´¾Í±»Oracleͨ¹ý²¢¹ºÆäÒÀÀµµÄ´æ´¢ÒýÇæInnobase¡¢BerkeleyDBÕÛÌڵIJ»ÐУ¬ÓÖÔÚ±»SunÊÕ¹ººó·¢ÉúÁËMonty´´½¨Ð·ÖÖ§MariaDBÕâÑùµÄÊÂÇ飬×îÖÕ»¹ÊÇËæ×ÅSunÒ»Æð±»Oracle²¢¹º£¬Ã»ÓÐÌÓÍÑLarry ElisonµÄħצ¡£Ò²Ðí£¬¿ªÔ´Èí¼þµÄºÃ´¦¾ÍÔÚ ......

MYSQL my.cnfÅäÖÃÖÐÎÄÏê½â

MYSQL--my.cnfÅäÖÃÖÐÎÄÏê½â ZZ2007Äê08ÔÂ16ÈÕ ÐÇÆÚËÄ 15:53mysqld³ÌÐò--Ŀ¼ºÍÎļþ
ÒýÓÃ
basedir = path   ʹÓøø¶¨Ä¿Â¼×÷Ϊ¸ùĿ¼(°²×°Ä¿Â¼)¡£
character-sets-dir = path   ¸ø³ö´æ·Å×Å×Ö·û¼¯µÄĿ¼¡£
datadir = path   ´Ó¸ø¶¨Ä¿Â¼¶ÁÈ¡Êý¾Ý¿âÎļþ¡£
pid-file = filename   Î ......

mysql¹ØÓÚÍøÉÏÁ÷תµÄ£¬Éú³É£³£¬£¶Ö®¼äµÄËæ»úÕûÊý

Èç¹ûÄãËÑË÷GOOGLE£¬Äã»áÕÒµ½ºÜ¶à¹ØÓÚmysqlµÄËæ»úÊý£¬ËûÃÇ»áÕâÑù˵
Éú³É£³£¬£¶Ö®¼äµÄËæ»úÕûÊý
FLOOR(3 + (RAND() * 6))
ÔÚ4ºóÃæÌí¼ÓÒ»¸ö3µ½6Ö®¼äµÄÕûÊý
CONCAT(343,FLOOR(3 + (RAND() * 6)))
ÔÚijһ×ֶκóÃæÌí¼Óһλ£³£¬£¶Ö®¼äµÄÕûÊý
UPDATE test SET xx= CONCAT(xx,FLOOR(3 +(RAND() * 6)));
µ«ÊÇÎÒ˽×Ô²âÊÔÁËһϣ¬ ......

MySQL connection strings

MySQL ODBC connection strings
Open connection to local MySQL database using MySQL ODBC 3.51 Driver
"Provider=MSDASQL; DRIVER={MySQL ODBC 3.51Driver}; SERVER= localhost; DATABASE=Your_MySQL_Database; UID= Your_Username; PASSWORD=Your_Password; OPTION=3"
MySQL OLE DB & OleDbConnection (.NET fr ......

MySQLѧϰ(3) ÊÓͼ£¬Óα꣬Óï¾ä¿é¶ù

1.MySQL´´½¨ÊÓͼµÄ¼òµ¥Óï¾äΪ£ºCREATE VIEW view_name  AS SELECT * from TABLE_NAME;
²»ÄܶԴ¥·¢Æ÷´´½¨ÊÓͼ(VIEW)¡£µ«ÊÇÔÚ5.1.4ÖÐÊÇÕâÑùÃèÊöµÄ£¬A view can be created from many kinds of SELECT statements. It can refer to base tables or other views. It can use joins, UNION, and subqueries¡£´óÖÂÒâ˼ÊÇÊÓÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ