ÏÖÓÐ×ֶΣº
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´
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......