mysql>select * from table into outfile ¡¯d:\test.xls¡¯
Èç¹û´ò²»¿ª ÊÇÂÒÂëÎÊÌâ Äãµ½ÍøÉÏÕÒһϠSQL code:
mysql>select * from table into outfile 'd:\\test.xls';
ÉÙÁËÒ»¸ö\ edo2008: µ¼³öCSVÎļþ£¬¿Éͨ¹ýEXCEL´ò¿ª¡£ mysql>select * from driver into outfile 'a.csv' fields terminated by ',' enclosed by '"'; µ¼³öCSVµÄ²»ÐÐÂð£¿phpmyadminºÍnavicat¶¼ÓÐÕâ¸ö¹¦ÄÜµÄ ºÜºÃ£¬Ð»Ð» ÄãÓÃPHPMYADMINÂð£¿ÄǶ«Î÷Ö±½ÓÉú³ÉXLS,³¬·½±ã£¡ select * from table1 into outfile 'a.csv' fields terminated by ',' enclosed by '"'; Õâ¸ö¾ÍÊÇÁË£¡£¡ ²»¹ý£¬Ã»Óùý£¬sqlÓï¾äµ¼¹ý£¡
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......