MySql×¢ÈëµÄÎÊÌâ
´ó¼ÒºÃ£¬ÎÒÓÃÎÒ×Ô¼ºµÄµçÄÔ×÷ΪʵÑé¶ÔÏó£¬ÒѾ¿ÉÒÔÔÚ±íµ¥ÖнøÐÐsql×¢Èë¶øÔÚÎÒµÄmysqlÖÐÌí¼ÓÁËÒ»¸öÓû§£¬È¨ÏÞºÍrootÒ»Ñù£¬ÄÇô½ÓÏÂÀ´ÎÒÏëÀûÓÃÕâ¸öн¨µÄÕ˺ŶÔÎҵĵçÄÔÀïµÄÎļþ½øÐвÙ×÷£¨°üÀ¨Ôö¼Ó»òɾ³ý£©£¬ÊÇ·ñ¿ÉÒÔʵÏÖ?ÁíÍ⣬±»mysql×¢ÈëÒÔºó£¬×îÑÏÖØµÄºó¹ûÄÜ´ïµ½ÔõÑù£¿Âé·³´ó¼Ò´Í½Ìһϣ¬Ð»Ð»
ÒýÓà LOAD_FILE(file_name) ¿ÉÒÔÓÃÕâ¸öº¯ÊýÀ´¶ÁÈκÎroot@localhostÓÐȨÏÞµÄÎļþ select ... INTO OUTFILE °ÑÐÅϢдÈëijÎļþ¡£ ¿ÉÒԲο¼Ò»ÏÂÎĵµÖеÄÏêϸ˵Ã÷ÓÃÀý×Ó¡£ MySQL¹Ù·½Îĵµhttp://dev.mysql.com/doc/refman/5.1/zh/index.html лл°æÖ÷µÄÀý×Ó£¬ÆäʵÎÒ×îÏëÖªµÀµÄÊÇ£¬±»×¢ÈëÖ®ºó×îÑÏÖØµÄºó¹ûÊÇʲô?³ýÁËÊý¾Ý¿âÖеÄÊý¾Ý»áй¶£¬±»É¾¸Ä£¬±»É¾³ýÖ®Í⣬ÊÇ·ñ¿ÉÒÔ¶Ô·þÎñÆ÷½øÐйÒÂí£¬»ò½øÐпØÖÆ£¿ÒýÓà ±»×¢ÈëÖ®ºó×îÑÏÖØµÄºó¹ûÊÇʲô? È¡µÃÄãÕû¸ö²Ù×÷ϵͳµÄ¿ØÖÆÈ¨¡£Ê²Ã´¶¼¿ÉÒÔ×öÁË¡£ ÒýÓà ³ýÁËÊý¾Ý¿âÖеÄÊý¾Ý»áй¶£¬±»É¾¸Ä£¬±»É¾³ýÖ®Í⣬ÊÇ·ñ¿ÉÒÔ¶Ô·þÎñÆ÷½øÐйÒÂí£¬»ò½øÐпØÖÆ£¿ Ò»Çж¼¿ÉÒÔ¡£ ËùÒÔ²»Òª¸øMysqld Ì«´óµÄȨÏÞ¡£ unixÖв»Òª¸ømysqlÓû§¹ý¶àµÄȨÏÞ¡£ windowsÖаѷþÎñÉèÖÃÖ¸¶¨Õ˺ÅÔËÐС£¼õÉÙȨÏÞ¡£ ¿ÉÒÔ˵˵ÔõôÑùÈ¡µÃÕû¸öϵͳµÄ¿ØÖÆÈ¨Â𣿻òÕßÓÐʲô×ÊÁÏ¿ÉÒԲο¼Ò»Ï£¬ÈçºÎͨ¹ýsql×¢Èë¶øÈ¡µÃÕû¸öϵͳµÄȨÏÞ£¿ÎÒgoogleµÃµ½µÄ´ó²¿·Ö¶¼ÊÇÈçºÎ·ÀÖ¹×¢È룬¶ø×¢Èë³É¹¦ÒÔºóÈçºÎ½øÐÐÆÆ»µÐÔ´óµÄ²Ù×÷È´Ò»Ö±¶¼ÕÒ²»µ½£¬²»ÖªµÀÊDz»ÊÇÎÒÕҵķ½·¨²»¶ÔÒýÓà ¿ÉÒÔ˵˵ÔõôÑùÈ¡µÃÕû¸öϵͳµÄ¿ØÖÆÈ¨Â𣿻òÕßÓÐʲô×ÊÁÏ¿ÉÒԲο¼Ò»Ï£¬ÈçºÎͨ¹ýsql×¢Èë¶øÈ¡µÃÕû¸öϵͳµÄȨ
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡ ±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿ Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml <Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......