mysqlµ¼ÈëÊý¾Ý¿âÎÊÌâ
ÔÚdocÏÂÖ´Ðе¼ÈëÃüÁî mysql -uadmin -padmin student < d:\a.txt ʱÌáʾϵͳÕÒ²»µ½Îļþ£¬»·¾³±äÁ¿¶¼ÉèÖöÔÁ˰¡£¬Ö®Ç°Ò²Ã»ÓгöÏÖ¹ýÕâ¸ö´íÎó£¬Çë´ó¼Ò°ïæ½â¾öÏ£¡Ð»ÁË£¡£¡
mysql -uadmin -padmin student < d:\\a.txt ÊÇÔÚϵͳDOSÏÂÖ´ÐеϹÊÇÔÚMYSQLÃüÁîÐÐÏÂÖ´ÐУ¿ Ó﷨û´í È·¶¨ÎļþÔÚÂ𣿠ÔÚdosÏÂcmd¿´¿´Îļþ£º SQL code: type d:\a.txt ÒýÓà mysql -uadmin -padmin student < d:\\a.txt Íü¼ÇÁË£¬¿ÉÄÜÎÒÒÔǰÓõÄÊÇ·´Ð±¸Ü£¬Ó÷´Ð±¸ÜµÄ»°¾ÍÖ»ÓÃÒ»¸ö¶Ô°É¸÷λ£¿£¿£¿ ÔÚϵͳDOSÏÂÓÃÒ»¸ö·´Ð±¸Ü¾Í¿ÉÒÔÁË£¬ÄãµÄϵͳÊÇWINDOWS£¿ÒýÓà ÊÇÔÚϵͳDOSÏÂÖ´ÐеϹÊÇÔÚMYSQLÃüÁîÐÐÏÂÖ´ÐУ¿ ÔÚϵͳDOSÏÂÖ´ÐÐ ÎļþҲȷʵ´æÔÚÒýÓà ÔÚϵͳDOSÏÂÓÃÒ»¸ö·´Ð±¸Ü¾Í¿ÉÒÔÁË£¬ÄãµÄϵͳÊÇWINDOWS£¿ windows xp C:\Documents and Settings\Administrator>mysql -u root -p <"D://test/z1.txt" C:\Documents and Settings\Administrator>mysql -u root -p <"D:\test\z1.txt" C:\Documents and Settings\Administrator>mysql -u root -p <"D:\test/z1.txt" C:\Documents and Settings\Administrator>mysql -u root -p <"D://test\z1.txt" ¶¼¿ÉÒÔ Ó¦¸Ã¿ÉÒÔ£¬ÓÐÎÞÈ«½Ç¡¢°ë½ÇÎÊÌ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º create uique index stu_cou_index on student_info.results (student_id, course_id); show index from student_info.results; ±£´æÎªindex ......
ÎÒ°²×°ºÃmysqlºó,ĬÈϵÄÊý¾Ý¿â·¾¶ÊÇÔÚCÅÌÏÂ,ÎÒÏë°ÑËü¸Äµ½EÅÌÀï: ÎÒÏȰÑmysql·þÎñÍ£Ö¹,ÔÙÔÚmysql°²×°Ä¿Â¼(Ò²ÊÇÔÚEÅÌ)ÏÂÕÒµ½my.iniÎļþ,¾Í¸ÄÁËÏÂÃæÄÇô¶à: #Path to the database root datadir="E ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿ ÄãÊÇÈçºÎɾ³ýµÄ£¿ ÓÐʲôÌáʾ£¿ ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
ÎÒµÄϵͳÊÇwindows XPµÄ,ÉÏ´ÎÓõçÄÔʱ¿ÉÒÔÔËÐÐmysql,µ«¹Ø»úºó,¸ô¶Ïʱ¼äÔÙ¿ª»ú,mysql¾Í²»ÄÜÕý³£ÔËÐÐÁË......¿ª»úºó,Mysql·þÎñÊÇ¿ªÆôµÄ,½ø³ÌÀïÃæµÄmysqld.exeµÄCPUÕ¼ÓÃÂÊΪ00,ÄÚ´æÊ¹ÓÃΪ72k(ºÍÎÒÉÏ´ÎÕý³£Ê¹ÓÃmysqlʱµÄ ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡ Çë¸÷λ¸øÒÔÌáʾ¡£ ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É 1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......