Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óï¾äµ¼¹ý£¡


Ïà¹ØÎÊ´ð£º

ASP +Mysql proc

ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ­»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......

°ïæ¿´¿´MySQLÓйصÄÅú´¦ÀíÎļþµÄÓï·¨

echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£

echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......

MYSQLÈçºÎÓëC++Á¬½Ó£¿ - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST 
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

MySQL´íÎó - PHP / »ù´¡±à³Ì

ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿

ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ

¿ÉÒÔÓÃÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ