MySQLÖÐÊý¾Ý½á¹û¼¯·ÖÒ³¹¦ÄܵÄʵÏÖ·½·¨
---------------------------------------------------------------------------
---- ±¾ÎÄΪandkylee¸öÈËÔ´´£¬ÇëÔÚ×ðÖØ×÷ÕßÀͶ¯³É¹ûµÄÇ°ÌáϽøÐÐתÔØ£»
---- תÔØÎñ±Ø×¢Ã÷Ôʼ³ö´¦
:
http://blog.csdn.net/andkylee
--- 2010-05-31 18:46:12
---- ¹Ø¼ü×Ö£º MySQL ·ÖÒ³ limit
----------------------------------------------------------------------------
Ä¿Ç°B/S¼Ü¹¹µÄÈí¼þ´óÐÐÆäµÀ¡£Í¨¹ýä¯ÀÀÆ÷ÈçºÎÏòÖÕ¶ËÓû§Ö»Õ¹Ê¾Ö¸¶¨Ò³ÃæÄÚÈݶø²»ÊÇÈ«²¿µÄ£¿±Ï¾¹·µ»ØÈ«²¿½á¹û¼¯£¬Ê±¼äºÍ¿Õ¼ä¿ªÏú¶¼ºÜ´ó¡£
Èç´ËÇé¿öÏ£¬¶ÔSQL·µ»Ø½á¹û¼¯½øÐзÖÒ³ÊǸöºÜ²»´íµÄ½â¾ö·½°¸¡£
±¾ÎÄÖ÷Òª½éÉÜMySQLÊý¾Ý¿âÖеķÖҳʵÏÖ·½Ê½¡£ÎÒÒÔÒ»¸öÊý¾Ý¿â¹ÜÀíÔ±µÄ½Ç¶È½øÐÐ˵Ã÷£¬ÖÁÓÚ¾ßÌåµÄʵÏÖ»¹ÐèÒª¿ª·¢ÈËÔ±Ïêϸ±àд¹ý³Ì¡£
×ܵÄ˵À´£¬ÔÚMySQLÖÐʵÏÖ·ÖÒ³¹¦ÄÜÊǺܼòµ¥µÄÊÂÇé¡£MySQLÊý¾Ý¿âµÄ¿ª·¢ÈËÔ±Ìæ¹ã´óµÄʹÓÃÕß×ÅÏ룬ÌṩÁËÒ»¸ö¹Ø¼ü×ÖlimitÀ´ÊµÏÖÏÞ¶¨Ö¸¶¨·¶Î§µÄ¹¦ÄÜ¡£
ÏÂÃæ¼òµ¥½éÉÜ·ÖÒ³µÄ˼·¡£
ÔÚMySQL5.0.15-nt-maxϽøÐвâÊÔ¡£
1.н¨Ò»ÕÅÁÙʱ±í(MyISAM»òÕßInnoDBÀàÐ͵Ķ¼¿ÉÒÔ)£¬±¾²âÊÔ±íûÓÐʹÓÃ×ÔÔöÁС£
CREATE TABLE `andkylee` (
`id` int(11) NOT NULL,
`name` varchar(30) default NULL,
`sex` char(1) NOT NULL,
`age` smallint(6) default NULL,
`note` varchar(100) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2.²åÈë²âÊÔÊý¾Ý¡£ ÔÚÕâÀïÓÈÆä½éÉÜÒ»ÖÖ²åÈë´óÁ¿²âÊÔÊý¾ÝµÄ·½·¨¡£
ÏȲåÈë2ÌõÊý¾Ý£¬
insert into andkylee
values(1,'hanyuliu','F',25,'aaaaaaaaaa'),(2,'andkylee','F',33,'bbbbbbbbbb');
ÅúÁ¿²åÈëÊý¾Ý
ÔÚûÓÐ×ÔÔöÁеÄÇé¿öÏ£¬ÓÃÏÂÃæµÄÓï¾äÀ´ÊµÏÖ²åÈë“Öظ´”Êý¾Ý¡£
insert into andkylee
select id+(select max(id) from andkylee),name,sex,age,note from andkylee;
±¾Óï¾äÄܹ»¸´ÖƱíÒÑÓеÄËùÓмǼ£¬²¢ÇÒÄܹ»ÊµÏÖ“Ö÷¼üÁД×ÔÔö¡£
¿ÉÄÜÓеãȱÏݵÄÊÇ£ºÐèÒªÔÙselectÁбíÖÐÖð¸öд³ö¸÷¸öÁÐÃû¡£µ«ÊÇ£¬ºÃÏñº¬ÓÐ×ÔÔöÁеıíΪÁËʵÏÖ²åÈëÖظ´Êý¾Ý£¬Ò²±ØÐë°Ñ·Ç×ÔÔöÁж¼Ð´³öÀ´°É¡£ Èç¹ûÎÒ˵µÄ²»¶Ô£¬Çë¸æÖª¡£
Ñ»·²åÈëÖظ´Êý¾Ý£¬Ê¹µÃ±íÊý¾ÝÐÐÊýÒÔÖ¸Êý·½Ê½Ôö³¤¡£ ÔÙ°ÑÒÑÓеÄÊý¾Ý²åÈëµ½±íÄÚ£¬ÐÐÊý±äΪÒÔÇ°µÄ2±¶¡£
insert into andkylee
select id+(select max(id) from andkylee),name,sex,age,note from andkylee;
mysql> select count(*) from andkylee;
+----------+
Ïà¹ØÎĵµ£º
ÓÅ»¯MySQLÊý¾Ý¿â²éѯ
ÔÚÓÅ»¯²éѯÖУ¬Êý¾Ý¿âÓ¦ÓÃ(ÈçMySQL)¼´Òâζ×ŶԹ¤¾ßµÄ²Ù×÷ÓëʹÓá£Ê¹ÓÃË÷Òý¡¢Ê¹ÓÃEXPLAIN·ÖÎö²éѯÒÔ¼°µ÷ÕûMySQLµÄÄÚ²¿ÅäÖÿɴﵽÓÅ»¯²éѯµÄÄ¿µÄ
¡¡¡¡ÈκÎһλÊý¾Ý¿â³ÌÐòÔ±¶¼»áÓÐÕâÑùµÄÌå»á£º¸ßͨÐÅÁ¿µÄÊý¾Ý¿âÇý¶¯³ÌÐòÖУ¬Ò»ÌõÔã¸âµÄSQL²éѯÓï¾ä¿É¶ÔÕû¸öÓ¦ÓóÌÐòµÄÔËÐвúÉúÑÏÖØµÄ ......
ÏÂÃæÎÒ¸ø´ó¼Ò½éÉܼ¸ÖÖÔÚmysqlÊý¾Ý¿âÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨
·½·¨Ò»£º
ÔʼÃÜÂëÊÇ ckh
mysql -uroot -pckh
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
my ......
²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽âÆ京Òå¼°×÷Óã ......
phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall to undefined function 'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã ......
MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......