SQL ServerºÍMySQLÖÐTopÓ÷¨µÄÇø±ð
½ñÌìÁ·Ï°ÔÚJSPÒ³ÃæÖÐʵÏÖ·ÖҳЧ¹û£¬ÔÚ²éѯÓï¾ä·½ÃæÇ£³¶µ½ÁËtopµÄÓ÷¨¡£¼òÒª×öÒ»ÏÂ×ܽ᣺
ΪʵÏÖÀàËÆtopµÄ¹¦ÄÜ£¬ÎÒÃÇÔÚSQL ServerÖкÍMySQLÖÐʹÓõ½µÄSQLÓï¾äÊDz»Í¬µÄ¡£
1¡¢ÔÚSQL ServerÖУ¬ÎÒÃÇʹÓà select top N * from tablenameÀ´²éѯtablename±íÖÐÇ°NÌõ¼Ç¼¡£
2¡¢ÔÚMySQLÖУ¬ÎÒÃÇÔòʹÓÃselect * from tablename limit M,N À´ÊµÏÖÏàËƵÄЧ¹û£¬ÆäÖÐM±íʾ´ÓµÚM+1Ìõ¼Ç¼¿ªÊ¼£¬N±íʾ·µ»ØNÌõ¼Ç¼¡£
ÀýÈ磺´Óuses±íÖÐÈ¡³öµÚËÄÌõµ½µÚÁùÌõÕâÈýÌõ¼Ç¼£¬ÎÒÃǾͿÉÒÔÕâÑùд£º
¡¡¡¡¡¡¡¡1¡¢select top 3 * from users where userID not in(select top 3 userID from users)
¡¡¡¡¡¡¡¡2¡¢select * from users limit 3,3
Ïà¹ØÎĵµ£º
Ç°¶Îʱ¼ä°²×°MySQL, ·Ç³£Ë³Àû, ºÜ¿ì¾Í°²×°ÁË, È»ºó¾¹ý¼òµ¥µÄÅäÖÃ. ½øÈëMySQLµÄ¿ØÖÆ̨, ÊäÈëÃÜÂë. È»ºó¾Í˳ÀûµØ½øÈëµ½Á˹¤×÷״̬.
µ«Êǵ±ÎÒµÚ¶þÌì½øÈëMySQLµÄ¿ØÖÆ̨, ÊäÈëÃÜÂëʱ, µÎµÄÒ»Éùºó,Õû¸ö¿ØÖÆ̨¾ÍÏûʧÁË.ÖØÐÂÊÔÁ˼¸´Î, ÎÊÌâÒÀ¾É. ¾ÍÉÏÍø°Ù¶ÈÒ»ÏÂ,·¢ÏÖÓв»ÉÙÈËÓöµ½Í¬ÑùµÄÎÊÌâ, ºÜ¶àÈ˶¼ËµÊ±my.iniÅäÖôíÎó, ÓÚÊÇ´ò¿ ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
......