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

Ò»ÌõSQL²éѯ

ÏÖÓÐ×ֶΣº
id,stype,fromplace,toplace,scount,logyear,logmonth

±¸×¢£º
stype:ËÑË÷ÀàÐÍ
fromplace£º³ö·¢µØ
toplace£ºÄ¿µÄµØ
scount£ºËÑË÷´ÎÊý
logyear£º¼Ç¼Äê
logmonth£º¼Ç¼ÔÂ



ÏÖÔÚÏëÓÃÒ»ÌõSQLÓï¾ä¸ù¾ÝËÑË÷ÀàÐͲéѯÿÔÂÖУ¬ËÑË÷´ÎÊýÔÚǰ20µÄ¼Ç¼


¸Õ¸ÕÄǸöÌû×ÓÐ޸Ĺý£¬µ«ÊǺܶàÈ˶¼Ö»¿´×îÏȵÄÎÊÌ⣬ûÓÐ×¢Òâµ½ÎÒÐ޸ĺóµÄÄÚÈÝ£¬¹ÌÖØÐ·¢Ìû£¡
SQL code:
---------------------------------
-- Author: liangCK СÁº
-- Title : ²éÿ¸ö·Ö×éǰNÌõ¼Ç¼
-- Date : 2008-11-13 17:19:23
---------------------------------

--> Éú³É²âÊÔÊý¾Ý: #T
IF OBJECT_ID('tempdb.dbo.#T') IS NOT NULL DROP TABLE #T
CREATE TABLE #T (ID VARCHAR(3),GID INT,Author VARCHAR(29),Title VARCHAR(39),Date DATETIME)
INSERT INTO #T
SELECT '001',1,'×Þ½¨','ÉîÈëdz³öSQLServer2005¿ª·¢¹ÜÀíÓëÓ¦ÓÃʵÀý','2008-05-10' UNION ALL
SELECT '002',1,'ºú°Ù¾´','SQLServer2005ÐÔÄܵ÷У','2008-03-22' UNION ALL
SELECT '003',1,'¸ñÂÞ·òGroff.J.R.','SQLÍêÈ«ÊÖ²á','2009-07-01' UNION ALL
SELECT '004',1,'KalenDelaney','SQLServer2005¼¼ÊõÄÚÄ»´æ´¢ÒýÇæ','2008-08-01' UNION ALL
SELECT '005',2,'Alex.Kriegel.Boris.M.Trukhnov','SQL±¦µä','2007-10-05' UNION ALL
SELECT '006',2,'·É˼¿Æ¼¼²úÆ·Ñз¢ÖÐÐÄ','SQLServer2000¸ß¼¶¹ÜÀíÓ뿪·¢','2007-09-10' UNION ALL
SELECT '007',2,'ºú°Ù¾´','SQLServer2005Êý¾Ý¿â¿ª·¢Ïê½â','2008-06-15' UNION ALL
SELECT '008',3,'³ÂºÆ¿ü','SQLServer2000´


Ïà¹ØÎÊ´ð£º

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

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

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ