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

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Êý¾Ý¿â²éѯ
 
   ÔÚÓÅ»¯²éѯÖУ¬Êý¾Ý¿âÓ¦ÓÃ(ÈçMySQL)¼´Òâζ×ŶԹ¤¾ßµÄ²Ù×÷ÓëʹÓá£Ê¹ÓÃË÷Òý¡¢Ê¹ÓÃEXPLAIN·ÖÎö²éѯÒÔ¼°µ÷ÕûMySQLµÄÄÚ²¿ÅäÖÿɴﵽÓÅ»¯²éѯµÄÄ¿µÄ
¡¡¡¡ÈκÎһλÊý¾Ý¿â³ÌÐòÔ±¶¼»áÓÐÕâÑùµÄÌå»á£º¸ßͨÐÅÁ¿µÄÊý¾Ý¿âÇý¶¯³ÌÐòÖУ¬Ò»ÌõÔã¸âµÄSQL²éѯÓï¾ä¿É¶ÔÕû¸öÓ¦ÓóÌÐòµÄÔËÐвúÉúÑÏÖØµÄ ......

ÔÚmysqlÊý¾Ý¿âÖÐÐÞ¸ÄrootµÄÃÜÂë

ÏÂÃæÎÒ¸ø´ó¼Ò½éÉܼ¸ÖÖÔÚ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 ......

MySql ±íµÄÖ÷¼üË÷ÒýÎÊÌâ

²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽âÆ京Òå¼°×÷Óã ......

phpÁ¬½Ómysql²âÊÔºÍÅäÖÃ


phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall   to   undefined   function   'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã ......

OracleµÄNVL()º¯ÊýºÍMySQLÖеÄIfNull()º¯Êý

MS SQL ÖеÄIsNull()º¯Êý£º
IsNull ( check_expression , replacement_expression )
check_expression: ¿ÉÒÔÊÇÈκÎÀàÐÍ,½«Òª¼ì²éµÄ±í´ïʽ  ²»Îª¿Õ£¬·µ»ØËü
replacement_expression: ÀàÐͱØÐëºÍcheck_expressionÏàͬ£¬check_expressionΪnull£¬·µ»ØËü
Õâ¸öº¯ÊýµÄ×÷ÓþÍÊÇ£ºÅжÏcheck_expressionÊÇ·ñΪ¿Õ£¬Îª¿Õ¾Í·µ» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ