ÐÂÄêºÃ£¬Çë½Ì°ÑEXCELµ¼ÈëMYSQL Ó¦¸ÃÈçºÎ×ö£¡
ÎÒÏÖÔÚÓøö²âÊÔ±í 1.xls ÔÚe:\1.xls ÀïÃæ²âÊÔÊý¾Ý 1 123456 ÐÂÄêºÃ 2 234567 ·¢´ó²Æ 3 345678 À´ºÃÔË ÎÒÏë°ÑÕâ¸ö±íÀïµÄ¶«Î÷µ¼ÈëMYSQLÊý¾Ý¿âÖÐ ÓÃSQLÓï¾äÈçºÎʵÏÖ Çó½Ì Çë¸÷λÀÏʦָµã£¡£¡
ÎÞ·¨ÊµÏÖ, û°ì·¨Ö±½ÓÔڣͣ٣ӣѣÌÖÐÓãӣѣÌÓï¾äÀ´Ê¶±ð£Ø£Ì£ÓÎļþ¡£ ÄãÐèÒª°Ñ£Ø£Ì£ÓÎļþÁí´æÎª£Ã£Ó£Ö¸ñʽ£¬È»ºó¿ÉÒÔÓà LOAD DATA INFILE À´µ¼Èë¡£ ¹ØÓÚ LOAD DATA INFILE ¿ÉÒԲο¼Ò»Ï£ͣ٣ӣѣ̵ÄÊÖ²áÖеÄ˵Ã÷ºÍÀý×Ó¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html Çë²é¿´ÕâÁ½ÆªÎÄÕ£º http://blog.csdn.net/zf213/archive/2009/06/12/4264413.aspx http://blog.csdn.net/zf213/archive/2009/06/12/4264421.aspx ÓÃNAVICAT FOR MYSQL Èí¼þÒýÓà Çë²é¿´ÕâÁ½ÆªÎÄÕ£º http://blog.csdn.net/zf213/archive/2009/06/12/4264413.aspx http://blog.csdn.net/zf213/archive/2009/06/12/4264421.aspx ÏÈлл£¬µ«ÊÇÎÒÏÖÔÚÏëʵÏÖVCÖ±½Óµ¼Èë²»ÖªµÀ¿É·ñ£¿ÎҼǵÃexcelµ¼Èëµ½access¿ÉÒÔÕâÑùʵÏÖ¡£ÒýÓà ÎÞ·¨ÊµÏÖ, û°ì·¨Ö±½ÓÔڣͣ٣ӣѣÌÖÐÓãӣѣÌÓï¾äÀ´Ê¶±ð£Ø£Ì£ÓÎļþ¡£ ÄãÐèÒª°Ñ£Ø£Ì£ÓÎļþÁí´æÎª£Ã£Ó£Ö¸ñʽ£¬È»ºó¿ÉÒÔÓà LOAD DATA INFILE À´µ¼Èë¡£ ¹ØÓÚ LOAD DATA INFILE ¿ÉÒԲο¼Ò»Ï£ͣ٣ӣѣ̵ÄÊÖ²áÖеÄ˵Ã÷ºÍÀý×Ó¡£ MySQL¹Ù·½Îĵµhttp://dev.mysql.com/doc/refman/5.1/zh/index.html ллÀÏʦ£¬²éÁ˺ܶà×ÊÁϴ󲿷ÖÈ˶¼ÍƼöÓÃÄãÕâ¸ö·½·¨£¡ http://blog.chinaunix.net/
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml <Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
±í CREATE TABLE `ch1` ( `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT, `no` int(10) unsigned DEFAULT NULL, `dtime` datetime DEFAULT NULL, PRIMARY KEY (`id ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ ¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ ÓóÌÐòÔ ......