mysqlÎÞ·¨Æô¶¯
ÓôÃÆ£¡CSDNµÄ²©¿Í±à¼Æ÷ÓÒ±ßÔõôûÓÐÏÔʾ³öÀ´Íê°¡£¬¸ã¸öʲô“ÈçºÎʹÓÿͻ§¶Ëд²©¿Í”£¬º¦ÎÒÊäÈëµÄ×Ö¶¼±»ÄǸöÌáʾµ²×¡ÁË£¡
תÈëÕýÌ⣺
½ñÌìÒ»´óÔçÆðÀ´£¬´ò¿ªeclipseÆô¶¯tomcat£¬×òÍí»¹Õý³£ÔËÐеÄÒ»¸öÏîĿȴ±¨´í£¬¸øÎÒµÄÐÄÇéÕæÊÇÒ»¸ö´ò»÷ѽ~~ÐÂÄêµÚÒ»Ìì¾Í²»Ì«Ë³Àû£¡
¾¹ý¼ì²é²ÅÖªµÀʹÓõÄÊý¾Ý¿âmysqlûÓÐÆô¶¯£¬Í¨¹ýWINXPµÄϵͳ·þÎñÀ´Æô¶¯mysql¸øÎÒÌø³öÒ»¸ö´íÎóÀ´£¬“´íÎó 1067: ½ø³ÌÒâÍâÖÕÖ¹”
¾¹ýÍøÉÏËÑË÷£¬²ÅÖªµÀÊÇûÓÐmy.iniÕâ¸öÅäÖÃÎļþ£¬Ò²ÕÒµ½ÁËһЩ½â¾öÕâ¸öÎÊÌâµÄ°ì·¨£¬±ÈÈçн¨Ò»¸ömy.iniÎļþ£¬ÊäÈëһЩÅäÖÃÐÅÏ¢µÈ
ÕâÑù´¦Àí¹ýºóµ¹ÊÇ¿ÉÒÔÕý³£Æô¶¯mysql£¬²»¹ýÔÚÔËÐÐÏîÄ¿µÄʱºò£¬ÎÒ»¹ÊÇÓöµ½Á˲»¿ÉÖªµÄÊý¾Ý¿âÒì³£
×îºóÕÒµ½ÁËÒ»¸ö×î¼òµ¥°²È«²¢ÓÐЧµÄ·½·¨£º
ÔËÐÐmysql°²×°Ä¿Â¼ÏµÄbinĿ¼ÏµÄMySQLInstanceConfig.exeÖ´ÐÐÎļþ£¬Í¨¹ýËü¿ÉÒÔ´ÓÐÂÅäÖÃÒ»¸ömysqlʵÀý
һ·nextÏÂÈ¥£¬¾ÍÍòÊ´ó¼ªÁË£¬mysql³É¹¦Æô¶¯£¬ÏîĿҲÕý³£ÔËÐУ¡
ÁíÍ⣬ΪʲôÍùÌ컹Õý³£Æô¶¯µÄmysql½ñÌìÎÞ·¨Æô¶¯£¬ÅäÖÃÎļþΪºÎ»á¶ªÊ§£¬ÎÒ»¹²»ÖªµÀÔÒò£¬Ï£ÍûÓÐÖªµÀµÄÅóÓѸøÎÒ½âÊÍÒ»ÏÂ
Ïà¹ØÎĵµ£º
InnoDB
ºÍMyISAM
ÊÇÔÚʹÓÃMySQL
×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£»ù±¾µÄ²î±ðΪ£ºMyISAM
ÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDB
ÀàÐÍÖ§³Ö¡£MyISAM
ÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDB
ÀàÐ͸ü¿ì£¬µ«ÊDz»ÌṩÊÂÎñÖ§³Ö£¬¶øInnoDB
ÌṩÊÂÎñÖ§³ÖÒѾÍⲿ¼üµÈ¸ß¼¶Êý¾Ý¿â¹¦ÄÜ¡£
MyIASMÊÇIASM± ......
ÌâÄ¿£º¸ø¶¨Ò»¸ö·Ö¸î·û£¬ÔõÑùµÃµ½¸ø¶¨×Ö·û´®×îºóÒ»¸ö·Ö¸î·ûºóµÄ×Ö·û´®¡£ È磺‘fsb-ibees-zxj-fsbk’ ÔõÑùµÃµ½fsbk, ÒªÇó£ºjavaʵÏÖ£¬sqlʵÏÖ£¿sql¿ÉÒÔÊÇoracle£¬mysqlµÈʵÏÖ¡£
1.OracleʵÏÖ
SET SERVEROUTPUT ON;
DECLARE
str VARCHAR2(266):='123-890-ibees-zxj';--±»½âÎöµÄ×Ö·û´®
splitStr VARCH ......
¡¡¡¡ÊÂÎñÊÇDBMSµÃÖ´Ðе¥Î»¡£ËüÓÉÓÐÏÞµÃÊý¾Ý¿â²Ù×÷ÐòÁÐ×é³ÉµÃ¡£µ«²»ÊÇÈÎÒâµÃÊý¾Ý¿â²Ù×÷ÐòÁж¼ÄܳÉΪÊÂÎñ¡£Ò»°ãÀ´Ëµ£¬ÊÂÎñÊDZØÐëÂú×ã4¸öÌõ¼þ£º£¨ACID£©
¡¡¡¡Ô×ÓÐÔ£¨Autmic£©£ºÊÂÎñÔÚÖ´ÐÐÐÔ£¬Òª×öµ½“Ҫô²»×ö£¬ÒªÃ´È«×ö£¡”£¬¾ÍÊÇ˵²»ÔÊÐíÊÂÎñ²¿·ÖµÃÖ´ÐС£¼´Ê¹ÒòΪ¹ÊÕ϶øÊ¹ÊÂÎñ²»ÄÜÍê³É£¬ÔÚrollbackʱҲҪÏû³ý¶ÔÊ ......
MYSQLÔÚ C API ÖпÉÓõĺ¯Êý£º
mysql_affected_rows()
·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£
mysql_close()
¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£
mysql_connect()
Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£
mysql_change_user()
¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£
mysql_ ......
ƽʱÎÒÃÇÔÚʹÓÃMySQLÊý¾Ý¿âµÄʱºò¾³£»áÒòΪ²Ù×÷ʧÎóÔì³ÉÊý¾Ý¶ªÊ§£¬MySQLÊý¾Ý¿â±¸·Ý¿ÉÒÔ°ïÖúÎÒÃDZÜÃâÓÉÓÚ¸÷ÖÖÔÒòÔì³ÉµÄÊý¾Ý¶ªÊ§»ò×ÅÊý¾Ý¿âµÄÆäËûÎÊÌâ¡£
¡¡¡¡Ò»¡¢Êý¾Ý±¸·Ý½Ý¾¶
¡¡¡¡ÒòΪÕâ¸ö·½·¨Ã»Óеõ½¹Ù·½ÕýʽÎĵµµÄÑéÖ¤£¬ÎÒÃÇÔݳÆÎªÊÔÑé°É¡£
¡¡¡¡Ä¿µÄ£º±¸·ÝhostAÖ÷»úÖÐÒ»¸öMySQLÊý¾Ý¿â±¸·ÝTestA£¬²¢»Ö¸´µ½µ½hostB»úÖÐ ......