mysqlÊý¾Ýµ¼ÈëÎÊÌâ
±ÈÈç°ÑÒ»¸ö.txtÎļþµÄÄÚÈݵ¼Èëµ½mysqlÊý¾Ý¿âµÄÀïÃæµÄtxstÊý¾Ý¿âÀïÃæ£¬£¬Ò³Ãæ±àÂëµÄºÍÊý¾Ý¿âÀïÃæ¶¼ÊDzÉÓÃutf-8½øÐбàÂ루ÏîÄ¿±ØÐë²ÉÓÃutf-8±àÂ룩£¬µ«µ¼Èëµ½Êý¾Ý¿âÀïÃæÖÐÎÄÊÇÂÒÂ룬µ«µ¼Èë³öÀ´¿ÉÒÔÏÔʾÖÐÎÄ£¬£¬ÇëÎÊÔõô½â¾ö°¡ £¬£¬
ÓÃgb2312ºÍÉÏÃæµÄÇé¿öÒ²ÊÇÒ»Ñù£¨µ«ÓÖ²»ÄÜÓÃGB2312£©
ÄÄλ´ó¸ç˵Ï£¬£¬Ð¡µÜ¸Ð¼¤²»¾¡
¶÷ ÄãµÄÊÇlinuxϵͳ»¹ÊÇWINµÄ£¿
¸øÄ㼸¸öÃüÁî°É£¡
Perl code:
//ÏȽøÈëµ½ÄãµçÄÔµÄDÅÌ
D:\>cd AppServ\MySQL\bin
D:\AppServ\MySQL\bin\>mysql -u root -p
Enter password:123 //Õâ¸öÊÇÃÜÂë
mysql>use Êý¾Ý¿âÃû
mysql>source d:\wcnc_db.sql//ÐèÒªµ¼ÈëÊý¾Ý¿âµÄ·¾¶
win
WIN
ÎÒ¸øÁËÄãDOS ÃüÁîÁË
ÓÃÁËû£¿¿ÉÒÔ°É£¿
ºÃÏñ»¹ÊDz»Ðа¡
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......