Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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
 ¸ö¼Ç¼ÐÐ


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿âµÄ¡°Á¬½Ó³Ø¡±

תÌûÇë×¢Ã÷³ö´¦£¬²¢±£³ÖÎÄÕµÄÍêÕûÐÔ¡£
¶ÔMySQLÊý¾Ý¿âÀ´Ëµ£¬Í¬Ò»Ê±¿Ì£¬ÔÚͬһ¸öÁ¬½Ó£¨connection£©ÉÏ£¬Ö»ÔÊÐí½øÐÐÒ»¸ö²Ù×÷£¨query£¬etc.£©£¬Èç¹ûÄãµÄ³ÌÐòÊǶàÏ̵߳쬲¢ÇÒÄãÔÚ¶à¸öÏß³ÌÖж¼»áÀûÓÃͬһ¸öconnection¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÄÇô£¬¾ÍÓпÉÄÜ·¢ÉúÎÊÌâ¡£
ÀýÈ磬Äã¿ÉÄÜ»áÊÕµ½“Commands out of sync”µÄ´íÎó ......

MYSQL ʼþµ÷¶ÈµÄÀý×Ó

1.SET GLOBAL event_scheduler = ON;
2.show processlist;
3.´´½¨Ò»¸ö±í test Ö÷Òª×Ö¶Î no,name,sex,age
4.¶Ô¸Ã±í²åÈ缸ÌõÊý¾Ý
5.´´½¨´æ´¢¹ý³Ìadd_age
drop procedure if exists add_age;
delimiter|
create procedure add_age()
begin
  start transaction;
  update eventtest set age = age +1;
&n ......

mysql Ë÷Òý

1
Ë÷ÒýµÄÒâÒ壺
Óŵ㣺
Ë÷ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌØ¶¨ÖµµÄ¼Ç¼£¬Èç¹ûûÓÐË÷Òý£¬Ö´Ðвéѯʱ±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨Ãè±íÖÐËùÓмǼ£¬±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£
    
ȱµã£º
Ë÷ÒýÒªÕ¼ÓôÅÅ̿ռ䣻ÇÒÈκÎд²Ù×÷Éæ¼°µÄË÷Òý¸öÊý¶àµÄ»°»áÒýÆð½µËÙ£¬ÒòΪ
MySQL
²»½öÒª°Ñ¸Ä¶¯Êý¾ ......

phpѧϰ±Ê¼Ç£¨12£©:PHP+MYSQLÁôÑ԰壨ÏÂ

1¡¢Ìá½»±íµ¥JavascriptÑéÖ¤
<form action="" method="post" name="myform" onsubmit="return CheckPost();">
SCRIPT language=javascript>
function CheckPost()
{
 
if (myform.user.value=="")
 {
  alert("ÇëÌîдÓû§");
  myform.user.focus();
  return f ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ