½«Excelµ¼ÈëMySQLÊý¾Ý¿â
ÈçÌ⣬
ExcelÓëMySQL±íµÄ×ֶοÉÄܲ»Ò»Ñù¡£
±ÈÈ磬ExcelÓÐ5¸ö×ֶΣ¬MySQLÖ»ÐèÒªÆäÖÐ3¸ö×ֶΡ£
Çë¸÷λÐֵܽãÃÃÌṩºÃµÄ·½·¨»ò½¨Òé¡£
excel µ¼Èëdataset,ÔÙ±éÀú²Ù×÷dataset£¬Ð´ÈëMySQL
лл¥Éϵĸ÷λÐֵܣ¬£¬¿ÉÒÔÏêϸµãÂ𣬣¬£¬°³ÐÂÊÖ
°ÂÅÖµÄÍ·ÏñºÃ¿É°®Å¶
½Ó·Ö¡£¡£¡£
{{
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
±í
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
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
ÔÚmysqlµÄ½Å±¾Ä£Ê½Ï£¬-t±íʾÒÔ±í¸ñµÄÐÎʽÊä³ö½á¹û£¬Èç¹ûÐèÒªÖÆ±í·û¶¨½çµÄÊä³ö¿ÉÒÔÊ¡ÂÔ´ËÑ¡Ïî¡£ ÕâÑùµÄÊä³öÊǾßÓбí¸ñÐÎʽµÄÊä³ö£¬
Õâ¸öÊÇÊéÉÏ˵µÄ£¬Õâ¾ä»°ÊDz»ÊÇÓÐʲôÎÊÌ⣿
ÊDz»ÊÇÖÆ±í·ûºÍ±í¸ñÐÎʽ£¬²»ÊÇÒ»»ØÊ ......