mysqlÎÞ·¨Æô¶¯
ÓôÃÆ£¡CSDNµÄ²©¿Í±à¼Æ÷ÓÒ±ßÔõôûÓÐÏÔʾ³öÀ´Íê°¡£¬¸ã¸öʲô“ÈçºÎʹÓÿͻ§¶Ëд²©¿Í”£¬º¦ÎÒÊäÈëµÄ×Ö¶¼±»ÄǸöÌáʾµ²×¡ÁË£¡
תÈëÕýÌ⣺
½ñÌìÒ»´óÔçÆðÀ´£¬´ò¿ªeclipseÆô¶¯tomcat£¬×òÍí»¹Õý³£ÔËÐеÄÒ»¸öÏîĿȴ±¨´í£¬¸øÎÒµÄÐÄÇéÕæÊÇÒ»¸ö´ò»÷ѽ~~ÐÂÄêµÚÒ»Ìì¾Í²»Ì«Ë³Àû£¡
¾¹ý¼ì²é²ÅÖªµÀʹÓõÄÊý¾Ý¿âmysqlûÓÐÆô¶¯£¬Í¨¹ýWINXPµÄϵͳ·þÎñÀ´Æô¶¯mysql¸øÎÒÌø³öÒ»¸ö´íÎóÀ´£¬“´íÎó 1067: ½ø³ÌÒâÍâÖÕÖ¹”
¾¹ýÍøÉÏËÑË÷£¬²ÅÖªµÀÊÇûÓÐmy.iniÕâ¸öÅäÖÃÎļþ£¬Ò²ÕÒµ½ÁËһЩ½â¾öÕâ¸öÎÊÌâµÄ°ì·¨£¬±ÈÈçн¨Ò»¸ömy.iniÎļþ£¬ÊäÈëһЩÅäÖÃÐÅÏ¢µÈ
ÕâÑù´¦Àí¹ýºóµ¹ÊÇ¿ÉÒÔÕý³£Æô¶¯mysql£¬²»¹ýÔÚÔËÐÐÏîÄ¿µÄʱºò£¬ÎÒ»¹ÊÇÓöµ½Á˲»¿ÉÖªµÄÊý¾Ý¿âÒì³£
×îºóÕÒµ½ÁËÒ»¸ö×î¼òµ¥°²È«²¢ÓÐЧµÄ·½·¨£º
ÔËÐÐmysql°²×°Ä¿Â¼ÏµÄbinĿ¼ÏµÄMySQLInstanceConfig.exeÖ´ÐÐÎļþ£¬Í¨¹ýËü¿ÉÒÔ´ÓÐÂÅäÖÃÒ»¸ömysqlʵÀý
һ·nextÏÂÈ¥£¬¾ÍÍòÊ´ó¼ªÁË£¬mysql³É¹¦Æô¶¯£¬ÏîĿҲÕý³£ÔËÐУ¡
ÁíÍ⣬ΪʲôÍùÌ컹Õý³£Æô¶¯µÄmysql½ñÌìÎÞ·¨Æô¶¯£¬ÅäÖÃÎļþΪºÎ»á¶ªÊ§£¬ÎÒ»¹²»ÖªµÀÔÒò£¬Ï£ÍûÓÐÖªµÀµÄÅóÓѸøÎÒ½âÊÍÒ»ÏÂ
Ïà¹ØÎĵµ£º
ÌâÄ¿£º¸ø¶¨Ò»¸ö·Ö¸î·û£¬ÔõÑùµÃµ½¸ø¶¨×Ö·û´®×îºóÒ»¸ö·Ö¸î·ûºóµÄ×Ö·û´®¡£ È磺‘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 ......
×î½ü¼¸ÌìÏÐÀ´ÎÞÊ£¬±ã³¢ÊÔÁËÒ»ÏÂÓÃC²Ù×÷Êý¾Ý¿â£¬ÏÂÃæ±ãÊÇÎÒ²âÊԵľßÌå½á¹û£º
¿ª·¢»·¾³ÊÇwindows 7 ultimate(Ó¢Îİæ) IDE ÊÇvs 2008 professional ÖÐÎİæ,Êý¾Ý¿âÊÇmysql 5.1
Ê×ÏÈ£¬ÎÒÔÚMySQL¿âÖд´½¨ÁËÒ»¸ötest±í£º
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT ......
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XP
쵀Apache+PHP+MySQL
°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003
ϵͳϵݲװºÍÅäÖá£
1.
°²×°»·¾³
²Ù×÷ϵͳÊÇ Windows XP
ÖÐÎİæ, Apache,
PHP, MySQL
µÄ×îа汾ÊǽØÖ¹µ½ 2007.09.07
£¬·Ö±ðÔÚÆä¹ÙÍøÏÂÔØµÄ:
* Apache 2.2.6
£ºhttp://apache.mirror.phpchina.c ......
Õ⼸Ìì×öÒ»¸ö²éѯ£¬ÐèÒªÔÚÒ»¸öÖ¸¶¨µÄ½á¹û¼¯ÖнøÐвéѯ£¬ÀýÈ磺
select * from table_name where doc_id IN ('1dba', 'c20a', '907b')
ÆäÖÐIN×Ó¾äÖеÄdoc_idÁбíÊÇͨ¹ýµ÷ÓÃÒ»¸öÍⲿ½Ó¿Ú»ñµÃÒ»×édoc_id³£Á¿ÁÐ±í£¬È»ºóÔÚ±¾µØ¿âÖÐËÑË÷·ûºÏÕâ¸öÁбíµÄÊý¾Ý
¼Ç¼¡£ºóÀ´·¢ÏÖmysql·µ»ØµÄ½á¹û¼¯µÄÅÅÐòÊǰ´ÕÕÈë¿â˳Ðò¸ø³öµÄ£¬µ«ÊÇÎÒ ......
ÖÐÎÄÏÔʾÎÊÌâÒ»Ö±ÊÇÀ§ÈÅÎÒÃǵÄÒ»¸öÄÑÌ⣬²»ÐÅÄãÉÏgoogleËÑË÷һϣ¬ÕâÀàµÄÎÊÌâºÍ½â´ð¿ÉÒÔ˵ÊÇÆÌÌì¸ÇµØ£¬ºÃ¶àÍøÕ¾ÉõÖÁ½«ÆäÌá³öÀ´×÷ΪרÌâÀ´ÌÖÂÛ£¬¹ÜÖпú±ª£¬¿É¼ûÒ»°ß¡£
¿ªÊ¼Ò²ÔøÎªÕâ¸öÎÊÌâÍ·ÌÛ£¬ÉÏÍø²éÔÄ´óÁ¿µÄ×ÊÁϺͽâ¾ö·½·¨£¬ÖÕÓÚÕÒµ½ÁËÒ»Öּȼòµ¥ÓÖºÃÓõİ취£¬ÒÔJSP+MYSQL´æ´¢ÎªÀý£¬¼òµ¥½éÉÜÒ ......