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

û·ÖÁË£¬ÎʸöMysql²éѯµÄÎÊÌâ

ij¸ö±íµÄijÁеÄÖµ´Ó1——100£¬ÔõôÈÃËû°´´óСÅÅÐò°¡£¿
ÎÒÓÃselect * from db_table order by ÁÐÃû£¬ÏÔʾµÄ½á¹ûÊÇ1£¬10£¬100£¬11¡£¡£¡£ÕâÑùµÄ£¬ÎÒÏ£ÍûËüÏÔʾµÄÊÇ1£¬2£¬3£¬4¡£¡£¡£ÕâÑùµÄ
sf

order by ÄǸöÊý×Ö asc

ÿ·ÖÁË Ä㻹ÎÊ´íµØ·½ÁË ºÇºÇ

ĬÈϾÍÊÇascÁ˰É
ÒýÓÃ
order by ÄǸöÊý×Ö asc


ÒýÓÃ
ÿ·ÖÁË Ä㻹ÎÊ´íµØ·½ÁË ºÇºÇ


Mysql°æ×îµÍÒª20·Ö £¬Ë®ÇøÃ»ÓÐÏÞÖÆ

ÅÅÐòµÄÄÇÁÐŪ³ÉÊý×ÖÐ͵Ä
±ðŪcharÐÍ

ÄãÄǸöÊÇ×ֶεÄÊý¾ÝÀàÐÍÊÇ×Ö·ûÐ͵ģ¬ËùÒÔÅÅÁеÄʱºò¾Í°´×Ö·ûÐ͵ÄÅÅÁз½Ê½£¬Èç¹ûת³ÉÊý×ÖÀàÐÍ£¬¾ÍOKÁË

ÓеÀÀí
ÒýÓÃ
ÅÅÐòµÄÄÇÁÐŪ³ÉÊý×ÖÐ͵Ä
±ðŪcharÐÍ


ÁÐÀàÐÍÊÇ×Ö·û´®Ê±¾ÍÊÇÕâ½á¹û¡£
ͨ³£½â¾ö·½·¨ÓÐÒÔÏÂÁ½ÖÖ£º
1¡¢ÁÐÀàÐ͸ÄΪÊý×ÖÐÍ¡£
2¡¢²éѯ½á¹ûǰ²¹Á㣬²¹Áãºó½á¹û´®³¤¶È£½Áг¤¶È¡£

Ŷ£¬Ã÷°×ÁË£¬Ð»Ð»£¡


Ïà¹ØÎÊ´ð£º

ÐèÒªÊÓÆµ½Ì³ÌµÄÐÂÊÖ½ø php + mysql + apache ÅäÖÃ

Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´


......

ÓÃPHPÅÅÐòmysqlÎÊÌâ

²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......

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

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

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

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ºÅ