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

ÈçºÎ½«mysqlÊý¾Ý¿âÖеÄÊý¾Ýµ¼³öΪxls

ÈçºÎ½«mysqlÊý¾Ý¿âÖеÄÊý¾Ýµ¼³öΪxls£¿ ÔÚÏßµÈ
SQL code:

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 '"';

ÒýÓÃ
ÈçºÎ½«mysqlÊý¾Ý¿âÖеÄÊý¾Ýµ¼³öΪxls£¿ ÔÚÏßµÈ

µ¼³öCSVµÄ²»ÐÐÂð£¿phpmyadminºÍnavicat¶¼ÓÐÕâ¸ö¹¦ÄܵÄ

ºÜºÃ£¬Ð»Ð»

ÄãÓÃPHPMYADMINÂð£¿ÄǶ«Î÷Ö±½ÓÉú³ÉXLS,³¬·½±ã£¡

select * from table1 into outfile 'a.csv' fields terminated by ',' enclosed by '"';

ÒýÓÃ
ÄãÓÃPHPMYADMINÂð£¿ÄǶ«Î÷Ö±½ÓÉú³ÉXLS,³¬·½±ã£¡

Õâ¸ö¾ÍÊÇÁË£¡£¡
²»¹ý£¬Ã»Óùý£¬sqlÓï¾äµ¼¹ý£¡


Ïà¹ØÎÊ´ð£º

Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢

ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ 
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£

mysqlÃüÁîÐÐģʽÏÂ: ......

ΪʲôMySQL²»Ö§³ÖÖÐÎİ¡£¿£¿

ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë

Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ

Ö§³Ö£¬¼ì² ......

mysqlÊý¾ÝÕÒ»ØÄÑÌ⣬¸ß·Ö£¬¼±£¡£¡£¡

ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ