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

ÐÂÄêºÃ£¬Çë½Ì°Ñ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µÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

MysqlЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

±í
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 Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´ 
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ