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

Mysql limitÓ÷¨

1.SELECT
 
*
 
from
 
table
 LIMIT
1
,
20
;  
//
 ¼ìË÷¼Ç¼ÐÐ
2-21
   µÚÒ»¸ö²ÎÊý£º²éѯÆðʼÐУ¨´Ó0¿ªÊ¼£©
   µÚ¶þ¸ö²ÎÊý£º²éѯ¼¸Ìõ¼Ç¼
2.
SELECT
 
*
 
from
 
table
 LIMIT
5
,
-
1

//
 ¼ìË÷¼Ç¼ÐÐ
6
-
last.
3.
SELECT
 
*
 
from
 
table
 LIMIT 
5
;     
//
¼ìË÷ǰ 
5
 ¸ö¼Ç¼ÐÐ


Ïà¹ØÎĵµ£º

phpѧϰ±Ê¼Ç£¨11£©:MYSQLÔÚphp5ÖеÄÓ¦ÓÃ


1¡¢phpÓëmysql½¨Á¢Á¬½Ó
php.ini ¼ÓÔØmysql×é¼þ
extension=php_mysql.dllǰµÄ;È¥µô
exetension_dir=""·¾¶ÊÇ·ñÕýÈ·
PhpÁ¬½Ómysqlº¯Êý
mysql_connect:¿ªÆôMYSQLÁ¬½Ó
mysql_select_dir:´ò¿ªÒ»¸öÊý¾Ý¿â
@ºÍor die Òþ²Ø´íÎóºÍÌõ¼þÏÔʾ
mysql_connect("Ö÷»ú","Óû§Ãû","ÃÜÂë");  
mysql_sele ......

C#Á¬½ÓmysqlÊý¾Ý¿â

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql ......

MYSQLÖÐµÄ constraint Óë CONSTRAINT

һֱϰ¹ßʹÓÃСдµÄSQL±£Áô×Ö£¬Ã»Ïëµ½½ñÌì¾ÓÈ»Óöµ½ÁËÂé·³¹þ£¡£¡ºÍгһÏÂMYSQLÀ²£¡
»·¾³£ºServer version: 5.1.37-1ubuntu5 (Ubuntu)
alter table child_table_name
add constraint constraint_name

foreign key (column_1)
references reference_table_name(reference_column_1);
ºÍ
ALTER  TABLE child_t ......

¹ØÓÚmysql µÄorder by rand()

 ¹Ù·½ÊÖ²áÉÏÊÇÕâôдµÄ£º
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{f ......

mysqlÊý¾Ý¿â·¶Ê½Ïê½â

ÔÚÉè¼Æ¹ØÏµÊý¾Ý¿âʱÊÇÒª×ñÊØÒ»¶¨µÄ¹æÔòµÄ¡£ÓÈÆäÊÇÊý¾Ý¿âÉè¼Æ·¶Ê½ÏÖ¼òµ¥½éÉÜ1NF£¨µÚÒ»·¶Ê½£©£¬2NF£¨µÚ¶þ·¶Ê½£©£¬3NF£¨µÚÈý·¶Ê½£©ºÍBCNF£¬ÁíÓеÚËÄ·¶Ê½ºÍµÚÎ巶ʽÁôµ½ÒÔºóÔÙ½éÉÜ¡£ÔÚÄãÉè¼ÆÊý¾Ý¿â֮ʱ£¬ÈôÄÜ·ûºÏÕ⼸¸ö·¶Ê½£¬Äã¾ÍÊÇÊý¾Ý¿âÉè¼ÆµÄ¸ßÊÖ¡£
µÚÒ»·¶Ê½£¨1NF£©£ºÔÚ¹ØÏµÄ£Ê½RÖеÄÿһ¸ö¾ßÌå¹ØÏµrÖУ¬Èç¹ûÿ¸öÊôÐÔÖµ¶¼Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ