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

°ï濴һϣ¬Ôõôдsql ÅÅÐò

ÅÅÐòǰ
5 245 405
5 245 406
5 239 396
5 239 395
5 240 398
5 240 397
5 241 399
5 241 400
5 242 401
5 242 402
ÒªÇóÅÅÐòºó
5 245 405
5 245 406
5 239 395
5 239 396
5 240 397
5 240 397
5 241 398
5 241 400
5 242 401
5 242 402

ÏÈллÁË¡£


¸Ð¾õûʲô¹æÂɰ¡¡£¡£¡£¡£
     


order by ÁÐ2 ,ÁÐ3

ÒªÇóÅÅÐòºó
5 245 405
5 245 406
5 239 395
5 239 396
5 240 397
5 240 398
5 241 399
5 241 400
5 242 401
5 242 402
¼±£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡

5 245 405 ÕâÁ½¸öÊÇ235°É£¿
5 245 406
5 239 395
5 239 396
5 240 397
5 240 397
5 241 398
5 241 400
5 242 401
5 242 402

ÒýÓÃ
ÒªÇóÅÅÐòºó
5 245 405
5 245 406
5 239395
5 239396
5 240397
5 240398
5 241 399
5 241 400
5 242 401
5 242 402
¼±£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡

ÔÙ¼±Ò²²»ÐÐѽ£¬Äã×ܵÄ˵³öÀ´¹æÂɰÉ

²»ÊÇÁË£¬¾ÍÊÇ245£¬ËùÒÔ²ÅÕâô³î

......
select c1,c2,c3 from table
order by c1,c2,c3

ÎÒ¾ÍÊÇÏëÈÃ1¡¢2Áб£³Ö²»±ä£¬µÚ3ÁÐÉýÐòÅÅÁÐ

select c1,c2,c3 from table
group by c1,c2,c3
order by c3

ÒýÓÃ
ÎÒ¾ÍÊÇÏëÈÃ1¡¢2Áб£³Ö²»±ä£¬µÚ3ÁÐ


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

C#ºÍÊý¾Ý¿âSQL - MS-SQL Server / »ù´¡Àà

ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
  SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
  ......

ÇëÎÊASPÈçºÎÁ¬½Ó¶à¸öSQL SERVER£¿ - Web ¿ª·¢ / ASP

ÓÐÁ½¸ö»òÒÔÉϵÄÔ¶³ÌÊý¾Ý¿â£¬ÈçºÎÓÃASP¼ì²âÁ¬½ÓËٶȲ¢Á¬½Ó×î¿ìµÄMSSQLÊý¾Ý¿â£¿

ÓÐÕâÑùµÄASPº¯ÊýÂð£¿ÎÒGOOGLEÁËһϣ¬ÕÒ²»µ½¡£

PHP+MYSQLÏÂÓÐÕâÖÖÀý×Ó£º
PHP code:

Example:
$wgDBservers = array(
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ